Microsoft KB Archive/303369

= BUG: Service Manager of SQL Server 2000 Does Not Show MSDE 1.0 Services =

Article ID: 303369

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q303369



BUG #: 354761 (SHILOH_BUGS)



SYMPTOMS
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

If you install the SQL Server 7.0 version of Microsoft Data Engine (MSDE) first (Microsoft Data Engine 1.0), and you then install a named instance of SQL Server 2000 Standard or Enterprise Edition, the Services list box for the MSDE 1.0 default instance of SQL Server is blank in the SQL Server 2000 Service Manager dialog box. The services names in the Services list box is blank for the default instance if the default instance is MSDE 1.0.

The same behavior is also noted with an original installation of Microsoft SQL Server 6.5.

This problem does not occur if the Microsoft SQL Server 7.0 Personal, Standard, or Enterprise Edition is installed instead of MSDE 1.0.



CAUSE
When you install a named instance, the following registry key only lists the SQL Server 2000 named instances:

HKLM\SOFTWARE\MICROSOFT\Microsoft SQL Server\InstalledInstances



WORKAROUND
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To work around this behavior use these steps:  Use REGEDT32 and navigate to the following registry key:

HKLM\SOFTWARE\MICROSOFT\Microsoft SQL Server\InstalledInstances

In the InstalledInstances registry entry there is already an entry that represents the name of the named instance.

 Double-click the entry name for InstalledInstances, and then on the line underneath the instance name add: MSSQLServer

 Open the Service Manager, select the default instance, and then press Refresh services.... The services relating to MSDE 1.0 should now appear.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.

Keywords: kbbug kbpending KB303369

-

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

© Microsoft Corporation. All rights reserved.