If you configure an instance of SQL Server 2000 or SQL
Server 2000 Desktop Engine (also known as MSDE 2000) to disallow network
connections, that instance will not appear in the SQL Server 2000 Service
The SQL Server ODBC driver does not return instance names to
the SQL Service Manager if the instance does not support network
To work around this behavior, stop and then start the
service for the instance by following these steps:
- Right-click My Computer, and then click
- Double-click Services and Applications in
the left-hand screen.
- Double-click Services.
- Right-click the service for the instance of SQL Server. The
name of the service for a default instance of SQL Server 2000 is MSSQLServer.
The name of the service for a named instance of SQL Server 2000 is
- Click the action that you want applied to the instance,
such as stop or start.
Microsoft has confirmed that this is a
problem in SQL Server 2000.
Article ID: 814132 - Last Review: October 16, 2003 - Revision: 3.2
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 2000 Desktop Engine (Windows)