May 19, 2010 at 5:03 pm
I just want to be sure I am getting this correct, there is no way to export a local group with user names and passwords included (they are servers in a different domain with no trust so we have to use sql authentication on them) and import it on a different machine? We were trying to get all of our servers registered quickly by having the primary db create a local group for their particular servers and then let the group import it to speed up the process.
May 20, 2010 at 8:23 am
If there is, I am not aware of it nor could I find anything on it. We connect to over 75 production servers on various domains, but they all trust each other so Win Auth works fine for us. Ther are a couple in non-production environments that we use SQL logins. On these servers, we were forced to manually enter our login information at first connect.
August 13, 2010 at 10:49 am
I'm having the same issue, I exported from SQL 2005 and also tried from a side by side 2005/2008 import and each time I tried to import the registered servers into 2008 I got errors. I started importing each group until I got all in, then when I hit 'refresh' it gave me the 'key not valid for use in specified state' error and now I cannot see any registered servers.
I tried the deleting of the 'shell' folder under app data, but that didn't work either.
August 13, 2010 at 10:53 am
ok so I just figured out my issue...
I found 2 'Shell' folders...
\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools
\AppData\Local\Microsoft\Microsoft SQL Server\100\Tools\Shell
I had to remove both before it reset itself.
September 18, 2012 at 4:21 am
Cheers tpalmer. Anoter SSMS oddity where technically SSMS is correct but still not working as expected.
January 27, 2014 at 6:39 am
Deleting the RegSrvr.xml file didn't solve my issue. I'm still not able to import the registered servers from one computer to another.
It has worked in the past but just not to this one laptop.
Each time I try importing, I get the error of:
Key not valid for use in specified state. (System.Security)
Does anyone have any other suggestions?
February 4, 2014 at 10:08 am
Toni-256719, here's a "crazy" "other suggestion":
Open up both SSMS's side-by-side and manually create the reg'd servers in 2008 (or 2012) that are in 2005.
That's what I had to do today.
February 4, 2014 at 10:28 am
Gary, that's exactly what I have been doing.
There are a lot of servers to do that with but it was my only option.
Thanks for the suggestion, though.
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply