Cannot use SQL Server 7.0 tools after you remove SQL Server 2000

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: When you try to access Query Analyzer and other SQL Server 7.0 tools:
You might also see this error message when you start the SQL Server Service Manager.

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.

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.

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