SSDT 2012 crashes importing database

SSDT 2012 crashes importing database by Jamin Mace VTSP [Stonebridge]

Closed

as Fixed

Type:	Bug
ID:	780171
Opened:	2/27/2013 4:10:02 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

SSDT 2012 crashes importing database.

Operating system: Windows 8 Enterprise
SSD Versions: SSDT for visual studio 2012 December 2012 update

see thread for more information: http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/73d48e92-42be-4eba-9017-f488a94805a9

Possting partial error from the eventlog:

Application: devenv.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Security.Cryptography.CryptographicException
Stack:
at Microsoft.VisualStudio.Data.DataProtection.DecryptString(System.String)
at Microsoft.VisualStudio.Data.Tools.Design.Core.Common.SqlClient.ServerExplorerConnection.get_DisplayNameWithDatabase()
at Microsoft.VisualStudio.Data.Tools.Package.UI.DatabaseConnectionControl+ConnectionItem.Initialize(Microsoft.VisualStudio.Data.Tools.Design.Core.Common.SqlClient.ServerExplorerConnection)
at Microsoft.VisualStudio.Data.Tools.Package.UI.DatabaseConnectionControl.PopulateDatabaseCombo()
at Microsoft.VisualStudio.Data.Tools.Package.UI.DatabaseConnectionControl.DatabaseConnectionControl_Load(System.Object, System.EventArgs)
at System.Windows.Forms.UserControl.OnLoad(System.EventArgs)
at System.Windows.Forms.UserControl.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean)
at System.Windows.Forms.Control.CreateControl(Boolean)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)
at System.Windows.Forms.UnsafeNativeMethods.IntCreateWindowEx(Int32, System.String, System.String, Int32, Int32, Int32, Int32, Int32, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Object)
at System.Windows.Forms.UnsafeNativeMethods.CreateWindowEx(Int32, System.String, System.String, Int32, Int32, Int32, Int32, Int32, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Object)
at System.Windows.Forms.NativeWindow.CreateHandle(System.Windows.Forms.CreateParams)
at System.Windows.Forms.Control.CreateHandle()
at System.Windows.Forms.Control.get_Handle()

Details (expand)

English

SQL Server 2012 SP1

Developer Tools (SSDT, BIDS, etc.)

Other

English

Open SSDT 2012
Create new Database Project
right click the project in solution explorer
Click Import option
select "Database"

Imediately SSDT crashes and a message is shown that it must be restarted.

Visual Studio Crashes and restarts

Database structure should be imported into the project

X64

0 attachments

Posted by Ryan K. Riehle on 5/5/2013 at 9:06 AM

This is marked as fixed. I am getting this same exact issue. Where can I get the patch ?

Posted by Microsoft on 3/4/2013 at 2:43 PM

To get around this try "devenv /setup". There appears to be a serialized, hashed connection string in your registry causing a crypto error. If this doesn't fix it I'd need to use sysinternals registry watcher to figure out where that encrypted string is coming from and then remove it from the registry manually.

Posted by Jamin Mace VTSP [Stonebridge] on 2/28/2013 at 6:50 PM

Do you have any workaround to offer while waiting on the next release?

We have been using these projects in production and need a hotfix or something meanwhile

Posted by Microsoft on 2/28/2013 at 6:22 PM

Thanks for reporting this. A fix will be available with our next release (after December 2012).

Posted by Ryan K. Riehle on 5/6/2013 at 7:48 AM

I found the following workaround at http://stackoverflow.com/a/15644729/309020

Remove registry entries under HKCU\Software\Microsoft\VisualStudio\11.0\SSDT\ConnectionMruList