Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Monday, February 20, 2012

Registered Servers in EM disappear after your machine login changes

We recently migrated from a domain authentication structure to an Active Directory structure in my office and the 90+ SQL Servers that I had registered in SQL Server Enterprise Manager are no longer registered when I enter Enterprise Manager under my new AD login. If I go to [HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group] in the registry I do see all of my servers registered there, but can't access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the server registration process linked to my old SID, thus why I can't see them in EM with my new AD userID?
Thanks,
DaveYes, it has to do with the SID. I have some scripts that can export
registrations to a file, from which you can import them onto another/same
machine. But they are not useful anymore, as we don't have the old login
anymore.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:59A20FD6-C194-412C-998D-E45E17C204E1@.microsoft.com...
We recently migrated from a domain authentication structure to an Active
Directory structure in my office and the 90+ SQL Servers that I had
registered in SQL Server Enterprise Manager are no longer registered when I
enter Enterprise Manager under my new AD login. If I go to
[HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\
Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]
in the registry I do see all of my servers registered there, but can't
access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the
server registration process linked to my old SID, thus why I can't see them
in EM with my new AD userID?
Thanks,
Dave