A Look at the SQL Server Browser Service | Bob Pusateri - SQL

SQL Server Browser Service port

Faq / November 26, 2021

The SQL ServerBrowser program runs as a Windows 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
  • Connecting to dedicated administrator connection (DAC) endpoints

    For each instance of the Database Engine and SSAS, the SQL Server Browser service (sqlbrowser) provides the instance name and the version number. SQL Server Browser is installed with SQL Server.

    SQL Server Browser can be configured during setup or by using SQL Server Configuration Manager. By default, the SQL Server Browser service starts automatically:

  • When upgrading an installation.
  • When installing on a cluster.
  • When installing a named instance of the Database Engine including all instances of SQL Server Express.
  • When installing a named instance of Analysis Services.

Background

Prior to SQL Server 2000, only one instance of SQL Server could be installed on a computer. SQL Server listened for incoming requests on port 1433, assigned to SQL Server by the official Internet Assigned Numbers Authority (IANA). Only one instance of SQL Server can use a port, so when SQL Server 2000 introduced support for multiple instances of SQL Server, SQL Server Resolution Protocol (SSRP) was developed to listen on UDP port 1434. This listener service responded to client requests with the names of the installed instances, and the ports or named pipes used by the instance. To resolve limitations of the SSRP system, SQL Server 2005 introduced the SQL Server Browser service as a replacement for SSRP.

How SQL Server Browser Works

When an instance of SQL Server starts, if the TCP/IP protocol is enabled for SQL Server, the server is assigned a TCP/IP port. If the named pipes protocol is enabled, SQL Server listens on a specific named pipe. This port, or "pipe, " is used by that specific instance to exchange data with client applications. During installation, TCP port 1433 and pipe sqlquery are assigned to the default instance, but those can be changed later by the server administrator using SQL Server Configuration Manager. Because only one instance of SQL Server can use a port or pipe, different port numbers and pipe names are assigned for named instances, including SQL Server Express. By default, when enabled, both named instances and SQL Server Express are configured to use dynamic ports, that is, an available port is assigned when SQL Server starts. If you want, a specific port can be assigned to an instance of SQL Server. When connecting, clients can specify a specific port; but if the port is dynamically assigned, the port number can change anytime SQL Server is restarted, so the correct port number is unknown to the client.

Upon startup, SQL Server Browser starts and claims UDP port 1434. SQL Server Browser reads the registry, identifies all instances of SQL Server on the computer, and notes the ports and named pipes that they use. When a server has two or more network cards, SQL Server Browser returns the first enabled port it encounters for SQL Server. SQL Server Browser support ipv6 and ipv4.

When SQL Server clients request SQL Server resources, the client network library sends a UDP message to the server using port 1434. SQL Server Browser responds with the TCP/IP port or named pipe of the requested instance. The network library on the client application then completes the connection by sending a request to the server using the port or named pipe of the desired instance.

For information about starting and stopping the SQL Server Browser service, see SQL Server Books Online.

Using SQL Server Browser

If the SQL Server Browser service is not running, you are still able to connect to SQL Server if you provide the correct port number or named pipe. For instance, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.

However, if the SQL Server Browser service is not running, the following connections do not work:

  • Any component that tries to connect to a named instance without fully specifying all the parameters (such as the TCP/IP port or named pipe).
  • Any component that generates or passes serverinstance information that could later be used by other components to reconnect.
  • Connecting to a named instance without providing the port number or pipe.
  • DAC to a named instance or the default instance if not using TCP/IP port 1433.
  • The OLAP redirector service.
  • Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.

    If you are using SQL Server in a client-server scenario (for example, when your application is accessing SQL Server across a network), if you stop or disable the SQL Server Browser service, you must assign a specific port number to each instance and write your client application code to always use that port number. This approach has the following problems:

  • You must update and maintain client application code to ensure it is connecting to the proper port.
  • The port you choose for each instance may be used by another service or application on the server, causing the instance of SQL Server to be unavailable.

Clustering

SQL Server Browser is not a clustered resource and does not support failover from one cluster node to the other. Therefore, in the case of a cluster, SQL Server Browser should be installed and turned on for each node of the cluster. On clusters, SQL Server Browser listens on IP_ANY.

Note

When listening on IP_ANY, when you enable listening on specific IPs, the user must configure the same TCP port on each IP, because SQL Server Browser returns the first IP/port pair that it encounters.

Installing, Uninstalling, and Running from the Command Line

By default, the SQL Server Browser program is installed at C:Program Files (x86)Microsoft SQL Server90Sharedsqlbrowser.exe.

The SQL Server Browser service is uninstalled when the last instance of SQL Server is removed.

SQL Server Browser can be started from the command prompt for troubleshooting, by using the -c switch:

what is the difference between near future and simple future future in front of future in front of me bright future in front of great future in front of you the future in front of you future of front end development future of front-end development 2021 future of front end development 2020 future in asl future in japanese future in french future in latin future in sight future in 8 mile future in tagalog future inside the mattress future inside the mattress lyrics future inside future scala future inside future flutter future inside the mattress mp3 download future inside future inside the mattress download future inside the mattress mp3 future into future into meaning into future synonym into future movie into future treasures future looking into mirror meme future looking into mirror future tense into passive voice future like ours future like i never left future like ours argument future like i never left lyrics future like ours objections future like movies future like ours marquis future like pablo escobar future made of virtual insanity future made of virtual insanity lyrics future made of corning future made of glass video future is made of the same stuff as the present future tense of made the future of made in italy the future of made in china future near me future near rhymes future near earth asteroids future near future near sentence future near example near future report near future synonym future next to meryl streep future of next generation sequencing future of next js future of next generation future of next future of next plc future of next-generation sequencing for life sciences next future of epl future of ethereum future off facebook activity future off road vehicles future off white nike releases future off dat future off road suvs future off facebook activity reddit future off mask future on forsyth future on his phone future on donda future on computer meme future on russell wilson future on youtube future on tour future on purpose future of opposite distant future opposite of opposite of future in english opposite of future proof opposite of future oriented opposite of future date opposite of future crossword opposite of future state future out the mud future out of office message future outlook future outcomes future out of band future out the mud lyrics future out the mattress future outta time outdoor future future of outside sales uk future outside eu future islands outside lands future of outside broadcasting future over your head future over your head lyrics future over 55 communities future over the counter future over your head video future over acrylic paint future over your head instrumental future over my head future past duran duran future past tense future past present future past review future past meaning future past meme future past review duran duran future past duran duran lyrics future pro baseball future pro tour future pro goalie school future pro basketball goals future pro bowl locations future pro flag football future pro usa future pro sports management future since since future tense since future victory is sure since future perfect tense since future perfect continuous future generali since future poppin since my demo future after since future through choices future through training future through comics future through astrology future through date of birth future through football academy future through numerology future through palm reading future drive thru grocery store future drive thru future walk thru lyrics future till i introduced you future till my last breath till future tense until future notice future spoil her till she a brat lyrics wait till future is done motsatsen till future synonym till future future to the back future to comfortable future to completablefuture future to the streets future to the back meme

Source: docs.microsoft.com