Last week I needed to repair my installation of Windows and ended up reinstalling completely over the top of the existing OS, this lead to an error is SSMS when I wanted to use Registered Servers, I have added the error in it’s entirety below:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Security.Cryptography.CryptographicException: Key not valid for use in specified state.
at System.Security.Cryptography.ProtectedData.Unprotect(Byte[] encryptedData, Byte[] optionalEntropy, DataProtectionScope scope)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.ProtectData(String input, Boolean encrypt)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.get_SecureConnectionString()
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.get_ConnectionString()
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.get_ServerName()
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.AddRegisteredServerNode(RegisteredServer regSrv, TreeNodeCollection nodes)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.AddServerGroupToNodeCollection(ServerGroup group, TreeNodeCollection nodes, Boolean createRecursively)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.AddServerGroupToNodeCollection(ServerGroup group, TreeNodeCollection nodes, Boolean createRecursively)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.AddServerGroupToNodeCollection(ServerGroup group, TreeNodeCollection nodes, Boolean createRecursively)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.AddServerGroupToNodeCollection(ServerGroup group, TreeNodeCollection nodes, Boolean createRecursively)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.Initialize(ServerGroup localServerGroup, ServerType serverType, IServerType connDlgServerType, AddCentralManagementServerDelegate onAddCentralManagementServer, AddNewCentralManagementServerDelegate onAddNewCentralManagementServer, DeleteCentralManagementServerDelegate onDeleteCentralManagementServer, GetServiceProviderDelegate onGetService)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerControl.RegisteredServerControl_Load(Object sender, EventArgs e)
at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
at System.Windows.Forms.UserControl.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.UserControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
—————————————-
AppIDPackage
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
—————————————-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
—————————————-
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
—————————————-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6071
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
—————————————-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
—————————————-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
—————————————-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
—————————————-
SqlWorkbench.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
—————————————-
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
—————————————-
Microsoft.SqlServer.Instapi
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
—————————————-
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
—————————————-
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
—————————————-
Microsoft.SqlServer.Management.SDK.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
—————————————-
Microsoft.SqlServer.Management.Sdk.Sfc
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
—————————————-
Microsoft.SqlServer.Management.Reports
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
—————————————-
SsmsAutomator2008
Assembly Version: 5.5.49.0
Win32 Version: 5.5.49.0
CodeBase: file:///c:/Program%20Files/SQL%20Sentry/5.0/ssmsautomator2008.dll
—————————————-
Extensibility
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
—————————————-
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
—————————————-
Intercerve.SqlSentry.Remoting
Assembly Version: 5.5.49.0
Win32 Version: 5.5.49.0
CodeBase: file:///c:/Program%20Files/SQL%20Sentry/5.0/Intercerve.SqlSentry.Remoting.DLL
—————————————-
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///c:/Program%20Files/SQL%20Sentry/5.0/log4net.DLL
—————————————-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
—————————————-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
—————————————-
Intercerve
Assembly Version: 2.1.3.0
Win32 Version: 2.1.3.3
CodeBase: file:///c:/Program%20Files/SQL%20Sentry/5.0/Intercerve.DLL
—————————————-
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
—————————————-
Microsoft.SqlServer.Management.SqlStudio.Explorer
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Explorer.DLL
—————————————-
Microsoft.SqlServer.Management.Controls
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL
—————————————-
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
—————————————-
ObjectExplorer
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
—————————————-
Microsoft.SqlServer.Management.UserSettings
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL
—————————————-
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 built by: QFE
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
—————————————-
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
—————————————-
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
—————————————-
SqlMgmt
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
—————————————-
ConnectionDlg
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
—————————————-
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
—————————————-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
—————————————-
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
—————————————-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
—————————————-
Microsoft.SqlServer.Management.RegisteredServers
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.RegisteredServers/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.RegisteredServers.dll
—————————————-
Microsoft.SqlServer.SqlClrProvider
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
—————————————-
ykyupvuj
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
—————————————-
Microsoft.SqlServer.SString
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SString/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll
—————————————-
dfz3fy1q
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
—————————————-
Microsoft.SqlServer.Management.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.DLL
—————————————-
jeosnj9n
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
—————————————-
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
—————————————-
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
—————————————-
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
—————————————-
Microsoft.SqlServer.Smo
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
—————————————-
Microsoft.SqlServer.SqlEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
—————————————-
Microsoft.SqlServer.BatchParserClient
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.BatchParserClient/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParserClient.dll
—————————————-
Microsoft.SqlServer.BatchParser
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_32/Microsoft.SqlServer.BatchParser/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
—————————————-
msvcm80
Assembly Version: 8.0.50727.4927
Win32 Version: 8.00.50727.4927
CodeBase: file:///C:/Windows/WinSxS/x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5/msvcm80.dll
—————————————-
Microsoft.DataWarehouse
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.DLL
—————————————-
Microsoft.SqlServer.GridControl
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_32/Microsoft.SqlServer.GridControl/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll
—————————————-
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
—————————————-
Microsoft.SqlServer.Dmf
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Dmf/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Dmf.dll
—————————————-
Microsoft.SqlServer.PolicyEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.PolicyEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.PolicyEnum.dll
—————————————-
Microsoft.DataWarehouse.SQM
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
—————————————-
Microsoft.SqlServer.Sqm
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Sqm.DLL
—————————————-
Microsoft.SqlServer.Management.SqlStudio.ResourceMonitor
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/microsoft.sqlserver.management.sqlstudio.resourcemonitor.DLL
—————————————-
Microsoft.SqlServer.Management.ResourceMonitoring
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.ResourceMonitoring.DLL
—————————————-
Microsoft.SqlServer.Management.ResourceMonitorWidgets
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.ResourceMonitorWidgets.DLL
—————————————-
ObjectExplorerReplication
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
—————————————-
DundasWinChart
Assembly Version: 6.0.0.1722
Win32 Version: 6.0.0.1722
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/DundasWinChart.DLL
—————————————-
Microsoft.SqlServer.Management.Collector
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Collector/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Collector.dll
—————————————-
Microsoft.SqlServer.Management.CollectorEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.CollectorEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.CollectorEnum.dll
—————————————-
SQLEditors
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
—————————————-
Microsoft.VisualStudio.TextManager.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
—————————————-
SqlManagerUI
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlManagerUi.DLL
—————————————-
Microsoft.AnalysisServices
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
—————————————-
Microsoft.SqlServer.Management.MultiServerConnection
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Management.MultiServerConnection/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.MultiServerConnection.dll
—————————————-
RadLangSvc
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/RadLangSvc.DLL
—————————————-
Microsoft.VisualStudio.Package.LanguageService
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Package.LanguageService/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Package.LanguageService.dll
—————————————-
Microsoft.SqlServer.SqlParser
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlParser.DLL
—————————————-
Microsoft.VisualStudio.TextManager.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.8.0.dll
—————————————-
Microsoft.SqlServer.DataStorage
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll
—————————————-
Microsoft.SqlServer.Types
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Types/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Types.dll
—————————————-
Microsoft.SqlServer.Management.SqlStudio.Controls
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Controls.DLL
—————————————-
Microsoft.SqlServer.DlgGrid
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.DlgGrid/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DlgGrid.dll
—————————————-
Microsoft.SqlServer.SmoExtended
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SmoExtended/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SmoExtended.dll
—————————————-
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
—————————————-
DatabaseMailWizard
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/DatabaseMailWizard.EXE
—————————————-
Microsoft.SqlServer.WizardFramework
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.WizardFramework/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.WizardFramework.dll
—————————————-
Microsoft.SqlServer.CustomControls
Assembly Version: 10.0.0.0
Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
—————————————-
Microsoft.SqlServer.Management.RegisteredServersUI
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.RegisteredServersUI.DLL
—————————————-
System.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
—————————————-
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging=”true” />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Solution
The way to solve the issue is to hunt down the file RegSrvr.xml and rename it. The problem is that the old file could not be read by the new installation of SQL Server, once this has been renamed or deleted the feature will work again.
I found the file in:
C:\Users\[USERNAME]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml
but if you have a local profile you will no doubt find it at:
C:\Users\[USERNAME]\AppData\Local\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml
If you’re running SQL 2005, substitute the 100 directory for 90