Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Stumper?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ajthepoolman
Constraint Violating Yak Guru

USA
384 Posts

Posted - 10/06/2004 :  12:30:39  Show Profile
I have recently received a new computer here at work. This is a wonderful thing except that all the databases I had mapped in Enterprise Manager are of course gone.

Is there a place on my old computer that I can go to and copy those map settings into my new box?

Thanks!

Adrian

X002548
Not Just a Number

15586 Posts

Posted - 10/06/2004 :  13:06:32  Show Profile
Yo! Pool Dude.

7 more posts!

[Danger Wil Robinson...there be WAGs]

And this is just a guess....make sure to backup the original before you try...

Try and copy this

SQL Server Enterprise Manager.MSC

To your new box....

[/Danger Wil Robinson...there be WAGs]



Brett

8-)
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

USA
384 Posts

Posted - 10/06/2004 :  13:27:08  Show Profile
Thanks Brett, I will give it a try and report back!

Adrian
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 10/06/2004 :  14:26:17  Show Profile  Visit tkizer's Homepage
I've never tried the MSC way so I don't know if that'll work. What I know works is exporting the registry entries and importing that into the new box. How many servers are we talking about? BTW, I don't remember the registry entry as it has been over 2 years since I've done that hack.

Tara
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

USA
384 Posts

Posted - 10/06/2004 :  16:09:46  Show Profile
For myself, I have 6 registrations.

My supervisor is linked up to about 9 or 10.

Can you give some further advice on the registry hack Tara?

Adrian
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 10/06/2004 :  16:13:50  Show Profile  Visit tkizer's Homepage
Found it:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

This is for SQL Server 2000 only. The 70 and 65 servers are located elsewhere.

Tara
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

USA
384 Posts

Posted - 10/06/2004 :  16:54:27  Show Profile
The registry hack worked!!!!

Thank you Tara! (and brett, sort of )

Adrian
Go to Top of Page

AndyThissen
Starting Member

USA
7 Posts

Posted - 04/04/2005 :  13:59:58  Show Profile
Any other ideas on what I need to export to move my EM settings to a new PC? I tried both the reg and the file copy. The new Enterprise Manager only sees the Groups I had created on the old client. Your help is appreciated.

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 04/04/2005 :  14:06:58  Show Profile  Visit tkizer's Homepage
Did you copy all of the string values underneath each eky in Registered Servers X? To do this, highlight Registered Servers X, go to File..Export. Save it to a file. Copy that file name over to your new box. Double click on it. Is that what you did? If so, I've never seen it not work for 2000 servers. Do you have a mix of 2000 and other older versions of SQL Server?

Tara

Edited by - tkizer on 04/04/2005 14:07:32
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000