RE: msde 2000 on windows 2003 server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ashish Ruparel [MSFT] (v-ashrup_at_online.microsoft.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 00:30:29 GMT

Hi,

I have found the following KB article that describes a similar scenario.

http://support.microsoft.com/default.aspx?scid=kb;en-us;814132&Product=sql2k
#appliesto

============================================================================
===========================================================

BUG: The SQL Server 2000 Service Manager Utility Does Not List Instances
That Have Not Enabled Network Connections
View products that this article applies to.

BUG #: 363267 (SHILOH_BUGS)

SYMPTOMS
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 Manager utility.

CAUSE
The SQL Server ODBC driver does not return instance names to the SQL
Service Manager if the instance does not support network connections.

WORKAROUND
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 Manage.
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
MSSQL$instancename.
Click the action that you want applied to the instance, such as stop or
start.

============================================================================
===========================================================

HTH

Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: SQL2000 disabled after installing Norton Antivirus 2005 (Solution)
    ... "Exit" on the notification icon of the SQL SErvice Manager. ... that MS Sql Server was already added during ... >> subsequently start the MSSQLServer Service Manager from the Program Files ...
    (microsoft.public.sqlserver.setup)
  • RE: question on sql icon near clock
    ... Windows Server 2003 are available for download on the Windows Update site ... This update will place the SQL Server Service Manager shortcut to launch at ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL service manager applet no longer in system tray
    ... You can find the Service Manager in the SQL Server Program group. ... > How do I get the service manager appleticon/icon back on desktop tray? ...
    (microsoft.public.sqlserver.msde)
  • sqlservr.exe doesnt stop
    ... >take all available processor time without me asking it to ... >stop it through Service Manager and if I do it ... >won't let me restart again. ... >computer but as soon as I tried to access SQL Server I ...
    (microsoft.public.sqlserver.security)
  • Re: there are some problem in service manager
    ... Co-Author: SQL Server 2000 Programming by Example ... > hi,i have a problem,in my sql server service manager. ...
    (microsoft.public.sqlserver.setup)