Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an instance of SQL Server 2000 SP4 running on Windows Server 2003 Standard Edition.

In the Services MMC snap-in, the SQL Server Browser service is not listed. I am looking for reasons why this service would be absent.

BTW, the following services ARE listed:

  • MSSQLServer
  • MSSQLServerADHelper
  • SQLSERVERAGENT
  • Microsoft Search
  • Distributed Transaction Coordinator
share|improve this question

1 Answer 1

up vote 2 down vote accepted

There is no SQL Server Browser service for SQL Server 2000. Each instance on the machine handles identifying itself independently.

share|improve this answer
    
+1 For more info look here: msdn.microsoft.com/en-us/library/ms181087.aspx –  squillman Mar 23 '11 at 20:56
    
Technically speaking, in SQL Server 2000 the first instance to start up on the server starts the SQL Server Listener, which does not show up as an independent service like SQL Server Browser (meaning you can't turn it off). The rest check in when they start up, if you are running multiple instances. This is one of the reasons that the SQL Server Browser Service came into being - SQL Slammer targeted the listener. –  K. Brian Kelley Mar 24 '11 at 9:14
    
I figured it was probably something like that, since it wouldn't be possible for every instance on the machine to listen on UDP port 1434 simultaneously. –  db2 Mar 24 '11 at 14:14
    
Is this answer still correct in the case where the SQL Server is in a clustered environment? I have confirmed that, on another SQL Server 2000 SP4 instance in a clustered environment, there is a service named "SQL Server Browser" running. –  echoScout Mar 25 '11 at 19:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.