What happens if SQL Server Browser service is stopped?

Question

If SQL Server Browser service is stopped and IP along with port number is not provided then connection will be refused. If SQL Server instance is configured using dynamic ports then browser service is required to connect to correct port number. 19 февр. 2010 г.

What is the purpose of SQL Server browser service?

SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions: Browsing a list of available servers. Connecting to the correct server instance.

Is SQL Server Browser necessary?

Yes. If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe.

Should SQL Server Browser service be disabled?

The SQL Server Browser service must be disabled unless specifically required and approved.

Is SQL Server Browser service needed for remote connections?

Any instance of SQL Server (assuming tcp/ip) can be identified by using the computer name or ip address and the port number. If you know both of these things (or SQL Server is listening on the default port of 1433) then you'll be able to connect without using the browser service as an intermediary.

Expert · Answer