SQL enterprise manager regisrations -- sql server clients

Anthony L.
2/6/2006 1:34:25 PM

we have a WIn2000 desktop and to be re-imaged with WIndows XP very soon,
any easy way to export/import all SQL servers registrations in Enterprise
Manager
it would be very painful to re-enter all these over 50 serer registrations
by hand...
???

also, the next step : if we're going to use SQL2005 mgmt Studio...
anyway to import these regisrations from SQl2000 EM ??

Christopher
2/8/2006 2:51:16 PM

Hello,

I have the same issue with 2 users here. they were moved off of a domain to
a new domain. All EM settings were lost. I did find the following registry
tree: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X.

this brings over the groups but not the servers. Any help would be
appreciated. We have over 70 servers. As mentioned, recreating manually
would most painful.

Any help would be great.

Thanks in advance.
Chris.

[quoted text, click to view]

Anthony L.
2/10/2006 6:05:27 AM

Christopher,
Your registry setting is good on Windows2000...I can export it to a reg file,
then edit and import to an XP workation, the registry settting on my XP is

[HKEY_USERS\S-1-5-21-1645522239-1614895754-839522115-6734\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
something like that...
(you have to modify the 2nd level base on the registry)
Thx
Anthony
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : SQL enterprise manager regisrations