Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 Import/Export Server Registrations Expand / Collapse
Author
Message
Posted Friday, May 20, 2005 12:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 1, 2010 3:53 PM
Points: 271, Visits: 2
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vDevasia/sqlserver2005importexportserverregistrations.asp
Post #184262
Posted Thursday, May 26, 2005 1:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 13, 2005 12:40 AM
Points: 32, Visits: 1

Exporting and Importing a sql group is fine. but i think there is no option to export or import selected servers within a group and also for selected server groups.

Narender

Hyderabad

Post #185306
Posted Thursday, May 26, 2005 2:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141, Visits: 61
What a great feature !  Well done Microsoft and thanks Vinod for showing us how to do this


Jon
Post #185313
Posted Thursday, May 26, 2005 3:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 15, 2006 5:21 AM
Points: 1, Visits: 1

An excellent GUI feature from Microsoft. For last 10 years, I have been exporting and importing the registry, which does the same job.

My approach is not recommended for ordinary users, but for DBAs it should very simple exercise.

 

Faisal Al-Boutiahi 

DBA - AXA Tech.

Post #185325
Posted Thursday, May 26, 2005 8:45 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:12 PM
Points: 3,475, Visits: 582

Faisal,

I have no problems exporting and importing registry entries for Registered Servers X but it only works for the same login. For example if I move the registrations ti another server, but I login to both as the same domain login.

This article too shows export and import working as the same Windows login. Are we sure the import will work for another user with different SID?

For some (understandable)  reason it does not work if I import this reg file logged as another user. The entries are in the Registry OK, but it just would not show in EM.

If you use Tools -> Options -> Read/Store User Independent then only new entries created after setting this option are available.

Do you know the way of making existing entries available for another user?

Thanks,

Yelena 

 




Regards,
Yelena Varshal

Post #185410
Posted Thursday, May 26, 2005 12:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 5:24 PM
Points: 1, Visits: 127
Nice feature, but the artcle could have been written in two paragraphs.  We can play with the gui on our own, thank you.


Post #185508
Posted Thursday, May 26, 2005 1:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 1, 2012 12:18 PM
Points: 60, Visits: 4
I, for one, appreciate the graphical examples.
Post #185534
Posted Thursday, June 8, 2006 8:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 30, 2013 10:16 AM
Points: 9, Visits: 103

SQL Server 2000 Enterprise Manager stores information about registered servers in the following registry branch:

HKEY_USERS\<UserSID>\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Server X.

The registry values are binary and can not be transferred to another computer because they depend on user SID and computer where EM is placed. The SQL Server 2005 Server Management Studio no longer uses the registry to store this information, so that registered servers can be transferred using export/import feature.

 

However, both 2000 and 2005 versions continue to use another registry branch that is very important for transferring registered server’s information, which isn’t mentioned in this article. When you manage a number of instances on the different servers and different domains it is very convenient to create aliases for those servers and use them for server registration. Both 2000 Client Network Utility and 2005 SQL Server Configuration Manager store alias information in this registry branch:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo.

So, if you import registered servers from 2000 EM to 2005 SMS on the same server, it works. On the other hand, if you use aliases and export registered servers from 2005 SMS, located on one server, to 2005 SMS, located on another server, the imported registered servers will appear on the SMS  “Registered Servers” window. However, you can’t connect to those servers, because the connection information is absent. In this case, you also need to import the registry branch that stores the alias properties.

 

Post #286158
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse