INF: Administering SQL Server 6.x and 7.0 From a Single Computer

ID: Q225545

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5, 7.0

SUMMARY

You cannot use SQL Server 7.0 Enterprise Manager (SEM) to administer previous versions of SQL Server. Likewise, you can not use previous versions of SQL Server Enterprise Manager to administer a SQL Server 7.0 server. You can ONLY REGISTER them.

If you attempt to register a 6.x server with 7.0 SEM 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 7.0 or later to be administered by this version of SQL-DMO.

You get a similar error if you are registering with a SQL Registration wizard.

If you attempt to register a 7.0 server with 6.x SEM 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 7.0(SQL DMO) to connect to this server) Register anyway?

If you click YES, you can only START and STOP SQL Server 7.0. If you click the PLUS SIGN (+) and try to expand it, it will not launch the SQL 7.0 SEM even though it is there on the same computer. That is the limitation with trying to administer SQL 7.0 Server from SQL 6.x SEM.

MORE INFORMATION

Pre-requisites:

You have SQL 7.0 Server on your computer and you want to Register SQL 6.x Server on this SQL 7.0 Server or vice versa.

Make sure you have SQL 6.5 & 7.0 client utilities (at least Enterprise Manager if not anything else) on the same computer.

Steps to register SQL 6.x server from SQL 7.0 server:

Start the SQL 6.x Enterprise Manager, right-click on the 6.x server group and choose "register server" from the context menu.

Enter the server name and the necessary authentication information and then close the screen.

Exit SQL 6.x Enterprise Manager.

Now, open the SQL 7.0 Enterprise Manager and you will find the SQL 6.x Server group and the server that you registered in previous steps.

Note that you can not administer from the SQL 7.0 SEM, you can only START and STOP the SQL 6.5 server.

When you click the PLUS SIGN (+) on the SQL 6.5 Server using the SQL 7.0 SEM to administer the SQL 6.5 Server, it launches a SQL 6.5 SEM and then you can perform the administration from there.

Additional query words: SQL 6.5, 6.x, 7.0, SEM, Enterprise Manager, Register, Registering, Administration, Administer

Keywords : kbSQLServ600 kbSQLServ650 kbSQLServ700
Version : winnt:6.0,6.5,7.0
Platform : winnt
Issue type : kbinfo