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

Posted on 2012-03-29
Medium Priority
Last Modified: 2012-04-03
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?
Question by:25112
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 29

Accepted Solution

Paul Jackson earned 1000 total points
ID: 37781790
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
LVL 25

Assisted Solution

TempDBA earned 1000 total points
ID: 37782786
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:-

Author Comment

ID: 37787076
jacko72, can you move the xml between 2005 and 2008 servers?
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.


Author Comment

ID: 37787084
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?
LVL 25

Expert Comment

ID: 37787489
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.

Author Comment

ID: 37801941
thank you Sirs..

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question