Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: SQL Server Service Manager Fails with "The system cannot find the file specified" Error Message


BUG #: 355015 (SHILOH_BUGS)

↑ Back to the top


Symptoms

When you open the SQL Server Service Manager, this error message may occur:

The system cannot find the file specified.
If you click OK the SQL Server Service Manager dialog box opens with the Server name properly listed; however, the Services drop-down listbox is empty.

If you click Start or Continue this error message appears:

The service control action cannot be completed as no service has been selected.

↑ Back to the top


Cause

On computers that have both SQL Server 2000 and Microsoft Data Engine Service Pack 1 installed, if you remove Microsoft Data Engine Version 2.0 Service Pack 1, then the SQL Server Service Manager is left in an inoperable state and the error messages described in the "Symptoms" section occur.

↑ Back to the top


Resolution

To resolve this problem, you must request the Refresh CD for MSDE, whose setup program correctly modifies the registry during an installation or removal of the program.

↑ Back to the top


Workaround

To correct the inoperable state of the SQL Server Service Manager, run the setup from the original SQL Server 2000 installation CD and select the Registry Rebuild option on the Advanced Options tab.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in Microsoft Data Engine Service Pack 1.

REFERENCES

For more information about using the Registry Rebuild option, see the "Rebuilding the Registry" topic in SQL Server 2000 Books Online.

↑ Back to the top


Keywords: kb, kbqfe, kbfix, kbbug, kbbillprodsweep

↑ Back to the top

Article Info
Article ID : 308010
Revision : 6
Created on : 9/29/2020
Published on : 9/29/2020
Exists online : False
Views : 95