Is SQL Server Browser necessary?

Question

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. 5 сент. 2017 г.

Do I need SQL Server browser running?

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. For example, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.

Should I disable SQL Server browser?

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

Can I uninstall SQL Server browser?

You can uninstall Microsoft SQL Server Browser from your computer by using the Add/Remove Program feature in the Window's Control Panel. When you find the program Microsoft SQL Server Browser, click it, and then do one of the following: Windows Vista/7/8/10: Click Uninstall.

What is SQL browser used for?

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.

Expert · Answer