Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Sql server browser service Expand / Collapse
Posted Friday, February 20, 2009 12:05 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:47 PM
Points: 586, Visits: 1,998

Can we connect to default or named instance through Management studio If the Sql server browser is disabled?

We have default sql server 2005 instance on server ABC. In server ABC, the sql server browser services has been disabled. But still Iam able to connect to the default instance ABC from Management studio.

and We have Second server XYZ, has named instance ins1.Here when I disable the Sql server Browser service, Iam UNABLE to connect to Ins1 from management studio?

Why in One server its working and NOT working in other server?

Do we really need to enable and start the sql sevrer browser service to connect to an instance from management studio?

Post #661610
Posted Friday, February 20, 2009 12:33 PM



Group: General Forum Members
Last Login: Friday, December 2, 2016 4:50 PM
Points: 23,515, Visits: 37,731
The default instance of SQL Server uses a known port (1433). The port assigned to a names instance is not known, or dynamically assigned. The browser service is what allows you to connect to the named instance without knowing what port it is connected to on the server.

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #661639
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse