Microsoft KB Archive/272453

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

Article ID: 272453

Article Last Modified on 11/17/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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


 * 1) 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.
 * 2) Rename the Sqlem.msc file to &quot;SQL Server Enterprise Manager.msc&quot; (without the quotes), and then confirm the rename.
 * 3) 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 &quot;SQL Server Enterprise Manager.msc&quot; file in the Mssql7\Binn folder. If you do not update the shortcut, you will continue to receive the error message described in the &quot;Symptoms&quot; 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

Additional query words: SEM ISQLW uninstall remove setup Enterprise Manager add programs

Keywords: kbprb KB272453

-

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

© Microsoft Corporation. All rights reserved.