Skip to content

Instantly share code, notes, and snippets.

@ststeiger

ststeiger/SQL_Browser_Port.txt

Created February 8, 2024 13:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ststeiger/89772bb8f44dad726c4738edaeedccaf to your computer and use it in GitHub Desktop.
Save ststeiger/89772bb8f44dad726c4738edaeedccaf to your computer and use it in GitHub Desktop.
Download ZIP
SQL Browser instance name lookup
Raw
SQL_Browser_Port.txt
The SQL Browser service typically listens on UDP port 1434.
When a client application requests connection information for a specific instance name,
it sends a query to the SQL Browser service on port 1434,
which then responds with the port number associated with the requested instance name.
If the UDP port 1434 is blocked by a firewall, the instance name to port lookup may fail,
resulting in connection issues when using instance names.
In such cases, connecting using the port number directly (e.g., SQL17,2673)
might work if the firewall allows traffic on the specific port.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment