Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

can you save 'registered servers' and take it to another workstation?

I have saved all the registered servers in one workstation for sql server r2.

can i somehow save this and take it to another workstation and bring it up there without having to register each one again?
0
25112
Asked:
25112
  • 3
  • 2
  • 2
2 Solutions
 
Paul JacksonSoftware EngineerCommented:
They are kept as an XML document here:

C:\Documents and Settings\username\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml

you can copy the file to the other workstations
0
 
TempDBACommented:
Better you create a central management server. This is a new feature which will help you centralize you registered servers and update it in all hosts whenever it gets modified. Check out the following link:-
http://msdn.microsoft.com/en-us/library/bb934126.aspx
0
 
25112Author Commented:
jacko72, can you move the xml between 2005 and 2008 servers?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
25112Author Commented:
TempDBA, that concept is to only run a same query is so many servers at one time, right? can you use it to transfer from one workstation to another?
0
 
TempDBACommented:
No, you can't. But all the workstations that can access the servers can connect to the central management server.
-Go to view -> Registered Servers -> Database Engine -> Central Management Servers ->Register Central Management Server -> Type the name -> And there you go.

So, basically its same as registered server, but the only difference is everyone doesn't need to make there local copy. A centralized one will do. And handling is also easy as all the reference tables are there in msdb database. So, it will be pretty easy.

Coming back to your exporting of the registered server, you can right click on the registered server -> task -> export.
Then in the other computer, you can do import in a similar fashion.
0
 
25112Author Commented:
thank you Sirs..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now