Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have just got SQL Server Mgmt Studio 2008 installed on my machine. Previously I was working with SQL Server Mgmt Studio 2005. I had stored a number of databases under Registered Servers in 2005. I am able to export these to a .regsrvr file from 2005. But I don't see any option in 2008 to import these.

Can you please advice on how the registered servers can be imported into SQL Mgmt Studio 2008?

Thanks :)

share|improve this question
up vote 1 down vote accepted

Open the registered servers window (View > Registered Servers) open Database Engine. Right click on Local Server Groups, then select Tasks then Import.

share|improve this answer
Yes, thanks. But I can't import the file exported from 2005 to 2008 as the xml formats are very different. – Rashmi Pandit Aug 2 '11 at 3:38
Do you still have access to the machine which had SQL 2005 on it? Can you upgrade that machine to SQL 2008? Or are you trying to do all this on one machine. – mrdenny Aug 2 '11 at 7:27
One machine. I have several servers registered, so I am just trying to migrate the registrations rather than re-creating all of them in 2008. – Rashmi Pandit Aug 2 '11 at 8:36
You should be able to right click on "Local Server Groups" select "Tasks" then "Previously Registered Servers" and it should import the information from the old registry keys. – mrdenny Aug 2 '11 at 23:25
Yes! Thanks mrdenny :) This has saved a lot of my time :D – Rashmi Pandit Aug 3 '11 at 3:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.