SQL Server 2008 R2 - .NET Framework unhandled exception

Question

I have installed SQL Server 2008 R2 on a new PC. Everything was working fine until I started exporting registered servers from the SQL Server 2008 R2 management studio which exist on my old PC. When I imported one of the registered servers to my new installation I got and error "Key not valid for use in specified state".

Now everytime I try to open registered servers on the new installation I get a .NET framework Unhandled Exception with the same message. The registered server area is completely empty. There is no way of adding any registered servers now. I have tried reinstalling SQL but the error remains. It is obviously related to the import process. Maybe something got corrupted. Does anyone know how to fix it?

Edit:Details from exception dialog

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.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)

stackoverflow.com/a/6476025/2990378 - this solution worked for me — MHS
– MHS, Commented Nov 14, 2013 at 3:14

Alan Spark · Accepted Answer · 2011-04-22 09:30:50Z

15

Sounds like it is something in your windows profile (e.g. Users/[Username]/AppData/Roaming on Windows 7). Have you tried clearing the SQL Server entries from that?

Alan

answered Apr 22, 2011 at 9:30

Alan Spark

8,3028 gold badges60 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user718982 Over a year ago

Thanks Alan. Spot on. The offending file was RegSrvr.xml. I renamed it and restarted SQL Server. Error has gone. I will continue to add my registered servers manually!!

Molomby Over a year ago

Worked for me too but mine was under \Users\[Username]\AppData\Microsoft\Microsoft SQL Server. Also, because of the way the domain I'm on is configured it wasn't on my local machine but off on a network drive.

zakirhas7 Over a year ago

Thanks Alan, This worked for me too after clearing the RegSrvr.xml

SeanClt Over a year ago

deleted the file RegSrvr.xml but now after login i get a null error and no databases shown under Databases

kukabuka · Accepted Answer · 2011-06-25 05:21:02Z

5

The RegSrvr.xml file was the problem for me too. But rather than delete the whole file, I just edited it to delete out the encrypted password strings. After that, Management Studio opened fine with all the imported servers present.

answered Jun 25, 2011 at 5:21

kukabuka

911 silver badge5 bronze badges

2 Comments

mghaoui Over a year ago

Brilliant! This is the solution.

Eric Barr Over a year ago

Similarly, I did another Export of the registrations from Sql Server Management Studio, but the second time I specified "Do not include user names and passwords in the export file". Then that imported fine into my new version instead of giving an error. So it seems that something goes wrong with including passwords in the SSMS export file.

John · Accepted Answer · 2011-05-27 14:31:35Z

2

I had avery similar situation. Exact same observations - but it had nothing to do with importing. I had done a complete reinstall of Windows 7, and SQL (Developer edition). I had recovered my profile from before the rebuild so it was out of sync with the install. I deleted C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL Server and the problem went away.

answered May 27, 2011 at 14:31

John

211 bronze badge

Comments

nathanchere · Accepted Answer · 2013-11-07 23:50:49Z

0

One more thing to check - you can't import exported definitions into earlier versions of SQL Management Studio. You'll get the same Key not valid for use error, for example, exporting from MSSMS2012 and trying to import in MSSMS2008R2.

answered Nov 7, 2013 at 23:50

nathanchere

8,10815 gold badges68 silver badges86 bronze badges

Comments

antew · Accepted Answer · 2015-03-31 11:43:29Z

0

One more thing to check - for me it was because there was no enough disk space in the drive of SQL Server. Clearing space resolved everything.

answered Mar 31, 2015 at 11:43

antew

9698 silver badges17 bronze badges

Collectives™ on Stack Overflow

SQL Server 2008 R2 - .NET Framework unhandled exception

5 Answers 5

4 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related