1

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
Improve this question

1 Answer 1

Reset to default
2

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

Improve this answer
4
  • +1 For more info look here: msdn.microsoft.com/en-us/library/ms181087.aspx Commented Mar 23, 2011 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. Commented Mar 24, 2011 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. Commented Mar 24, 2011 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. Commented Mar 25, 2011 at 19:19

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.