Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

What every DBA that manages a large number of SQL Servers should know about SQL 2008!!

Error when importing RegServer list from SQL 2005 to SQL 2008

I discovered the already known bug in SQL 2008 that you can't import a SQL 2005 server list (exported as a regsrvr file). For someone like me who deals with a large numger of SQL Servers, this is a major issue. Fortunately, Buck Woody has provided a simple solution on his Blog: Importing SQL Server 2005 Registered Servers to SQL Server 2008. This saved me a great deal of time and, more importantly, a great deal of annoyance!!

Thanks Buck!!

My Bug Report

I reloaded my laptop and installed a new installation of SQL 2008 RTM (Dev. Ed.). Previous setup was SQL 2005 SP2. Prior to wiping hard drive, I exported the registered servers to regsrvr files (1 for database engine, 1 for AS, and 1 for IS). I can’t import SQL 2005 regsrvr files into SQL 2008. For me, this is a big hindrance!! Is there a workaround?

When I try to import these files into the SQL 2008 SSMS, I get the following error for all 3 regsrvr files:

Cannot import from C:\Users\v-rodav\Desktop\SQLIS.regsrvr.
The operation 'Import' failed. (Microsoft.SqlServer.Management.RegisteredServers)
Serialization output is invalid. (Microsoft.SqlServer.Management.Sdk.Sfc)
'None' is an invalid XmlNodeType. Line 17, position 10. (System.Xml)

SQL 2008 SSMS Version info:

Microsoft SQL Server Management Studio      10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools      2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)      6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML      3.0 4.0 5.0 6.0
Microsoft Internet Explorer      7.0.6001.18000
Microsoft .NET Framework      2.0.50727.3053
Operating System      6.0.6001

Comments

Posted by bk on 31 October 2008

Buck mentions files but leads us to the regsrve.xml file.   Do we just copy the one file or is there more?  Did not work for me just bringing over the one file.  Please explain.   Thanks

Posted by Robert Davis on 18 February 2009

It depends on what all you have registered. There are separate files for SSIS, SSAS, Database engine, and SSRS servers. You will have as many files as types of servers registered. I had 3 files, 1 for SSIS, 1 for SSAS, and one for DE.

Posted by tsduke03 on 27 March 2010

This workaround did not work for me.

Posted by Ben Brannen-413038 on 7 April 2010

this workaround did not work for me either.  I've searched several sites all say the same.  What are we missing?

Posted by Robert Davis on 8 April 2010

Can you detail what you did?

Posted by pietje gates on 31 March 2011

At first this solution didn 't work for me.

Then I copied the file both into to SQL 90 and 100 folder

C:\Documents and Settings\Username\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell

and

C:\Documents and Settings\Username\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell

Then it worked for me.

Leave a Comment

Please register or log in to leave a comment.