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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment