Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Import/Export Server Registrations


SQL Server 2005 Import/Export Server Registrations

Author
Message
james bond-148358
james bond-148358
SSC Veteran
SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)SSC Veteran (271 reputation)

Group: General Forum Members
Points: 271 Visits: 2
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vDevasia/sqlserver2005importexportserverregistrations.asp
narender-165487
narender-165487
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
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


Jonr
Jonr
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 65
What a great feature ! Well done Microsoft and thanks Vinod for showing us how to do this :-)


Jon
Faisal Hassan Al-Boutiahi
Faisal Hassan Al-Boutiahi
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.


Yelena Varshal
Yelena Varshal
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3480 Visits: 593

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

dth6
dth6
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 159
Nice feature, but the artcle could have been written in two paragraphs. We can play with the gui on our own, thank you.



Andrew Lias
Andrew Lias
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 4
I, for one, appreciate the graphical examples.
Serhiy Snisarenko
Serhiy Snisarenko
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
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.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search