Cannot use SQL Server 7.0 tools after you remove SQL Server 2000 (272453)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q272453

SYMPTOMS

Sometimes Microsoft SQL Server 2000 (or the SQL Server 2000 client tools) and SQL Server 7.0 are installed on the same computer. If you remove SQL Server 2000, the following error messages might occur when you try to open various SQL Server 7.0 tools:

When you try to access SQL Server Enterprise Manager:
Microsoft Management Console

MMC cannot open the selected file.

When you try to access Query Analyzer and other SQL Server 7.0 tools:
Redirection EXE Error

The system cannot find the file specified.

You might also see this error message when you start the SQL Server Service Manager.

CAUSE

Only one instance of SQL Server 2000 tools is allowed. Although SQL Server 2000 may not be first in the PATH, during the SQL Server 2000 install the SQL Server 7.0 tools, executables, COM components and DLL files are replaced with redirectors so that the SQL Server 2000 version always starts.

WORKAROUND

Follow these steps to work around this behavior:
  1. Open a Command prompt, and then navigate to the \Mssql7\Binn folder.
  2. From the \Mssql7\Binn folder, run the following commands in the order listed: copy *.c70 *.exe
    copy *.e70 *.exe
    copy *.d70 *.dll
    regsvr32 dtsffile.dll
    regsvr32 dtspkg.dll
    regsvr32 dtspump.dll
    regsvr32 dtsui.dll
    regsvr32 sqldmo.dll
    regsvr32 sqllex.dll
    regsvr32 sqlmmc.dll
    regsvr32 sqlns.dll
    regsvr32 stardds.dll

  3. Copy the Sqlem.msc file located in the \X86\Binn folder of the SQL Server 7.0 CD to the \Mssql7\Binn folder on the local computer.
  4. Rename the Sqlem.msc file to "SQL Server Enterprise Manager.msc" (without the quotes), and then confirm the rename.
  5. You need to update the shortcut to Enterprise Manager in the SQL Server 7.0 program group of your Start menu so that it points to the "SQL Server Enterprise Manager.msc" file in the Mssql7\Binn folder. If you do not update the shortcut, you will continue to receive the error message described in the "Symptoms" section.

MORE INFORMATION

Following is a description of the file extensions for the SQL Server 7.0 files that are being copied:

*.c70 are command line utilities
*.e70 are executables
*.d70 are DLLs or COM components

Modification Type:MinorLast Reviewed:11/17/2004
Keywords:kbprb KB272453
©2004 Microsoft Corporation. All rights reserved.