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
- 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.