March 8, 2017 at 3:57 am
Dear all,
Let me put one question related with the SQL Browser Service.
Is it necessary if I have just one instance of SQL Server running on a computer (even if this SQL Server is lestning on a port like 40028)?
Or the browsing is only needed when we have more then one SQL Server instance?
Thank you.
March 8, 2017 at 4:16 am
SQL Server Browser only works for named instances, so if your instance is a default instance, you won't need it. Assuming you have a named instance, though, since it is listening on a non-standard port, you either need SQL Server Browser running, or all connections must specify the port number. This is all documented.
John
March 8, 2017 at 4:28 am
SQLBrowser returns the list of instances on a machine and the protocols+protocol details of a given instance.
You will need it whenever:
1) You are trying to connect to a named instance by specifying the instance name. In this case, the browser service returns the port number/named pipe to contact
2) You are trying to connect to a default instance listening on a non-default port
Cases when SQLBrowser is NOT needed:
1) You connect to a default instance listening on port 1433
2) You connect to a named instance listening on port 1433, without specifying an instance name
3) You connect to any instance by specifying the port number to contact in the form host,port
-- Gianluca Sartori
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply