Migrate SQL 2000 server registration to SQL 2005

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  December 12, 2007 at 10:31 am

  #122755

  We registered SQL Servers from SQL 2000 using EM. Is there any way to migrate the registration to SQL 2005?

  Many thanks for any input.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  December 12, 2007 at 2:49 pm

  #759606

  This works if you have SQL 2000 Enterprise Manager on the same computer.

  In SSMS:

  1. Click on "View" and select "Registered Servers"

  2. R-click on "Database Engine" and select "Previously Registered Servers"

  Your registered servers will be listed.

  Greg

  Greg