HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager (225545)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 2000 64 bit (all editions)
This article was previously published under Q225545

IN THIS TASK

SUMMARY

You cannot use SQL Server Enterprise Manager in SQL Server 7.0 to administer SQL Server 6.5 and earlier. Additionally, you cannot use SQL Server Enterprise Manager in SQL Server 6.5 or earlier to administer SQL Server 7.0 or later. You can only register computers running different versions of SQL Server by using SQL Server Enterprise Manager.

If you try to register a computer running SQL Server 6.x server by using SQL Server Enterprise Manager in SQL Server 7.0, you receive the following error message:
A connection could not be established to server_name - [SQL-DMO]SQL Server server_name must be upgraded to version %s or later to be administered by this version of SQL-DMO.
You receive a similar error message if you try to register a computer running SQL Server by using the Register Server Wizard.

If you try to register a computer running SQL Server 7.0 or later by using SQL Server Enterprise Manager in SQL Server 6.x, you receive the following error message:
Unable to connect to Server(reason:(SQL Server) You must upgrade your SQL Enterprise Manager and SQL DMO(SQL OLE) to version %s(SQL DMO) to connect to this server) Register anyway?
If you click Yes, you can only start and stop the computer running SQL Server 7.0 or later. If you try to expand the computer running SQL Server 7.0 or later, it does not open, although it is installed on the computer. This limitation occurs when you try to administer a computer running SQL Server 7.0 or later by using SQL Server Enterprise Manager in SQL Server 6.x.

back to the top

Prerequisites

Make sure that the following prerequisites are met:
  • Your computer is running SQL Server 7.0 or later, and you want to register SQL Server 6.x on that computer.

    -or-
  • Your computer is running SQL Server 6.x, and you want to register SQL Server 7.0 or later on that computer.
  • You installed SQL Server 6.5 and SQL Server 7.0 or later client utilities (at least SQL Server Enterprise Manager) on the same computer.
back to the top

Register a Computer Running SQL Server 6.x from a Computer Running SQL Server 7.0

To register a computer running SQL Server 6.x from a computer running SQL Server 7.0, follow these steps:
  1. Start SQL Server Enterprise Manager in SQL Server 6.x, right-click the 6.x server group, and then click Register Server.
  2. Enter the server name and the authentication information, and then close the dialog box.
  3. Quit SQL Server Enterprise Manager in SQL Server 6.x.
  4. Start SQL Server Enterprise Manager in SQL Server 7.0, and then locate the SQL Server 6.x server group.
  5. Note that you cannot administer this server group SQL Server Enterprise Manager in SQL Server 7.0; you can only start and stop the SQL Server 6.x server group.
  6. If you try to expand the computer running SQL Server 6.x, SQL Server Enterprise Manager in SQL Server 6.x starts. You can then use SQL Server Enterprise Manager in SQL Server 6.x to administer the computer.
back to the top
Modification Type:MajorLast Reviewed:1/20/2004
Keywords:kbHOWTOmaster kbinfo KB225545 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.