Microsoft KB Archive/225545

= HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager =

Article ID: 225545

Article Last Modified on 1/20/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 2000 64-bit Edition

-



This article was previously published under Q225545



IN THIS TASK

 * SUMMARY
 * Prerequisites
 * Register a Computer Running SQL Server 6.x from a Computer Running SQL Server 7.0 or Later



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  - [SQL-DMO]SQL Server   must be upgraded to version   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 (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

Keywords: kbhowtomaster kbinfo KB225545

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.