Start and Stop SQL Server Browser Service
It's possible to start/stop the service using SQL Server Configuration Manager or Services.msc.
If we stop the SQL Server browser services then we will not connect through named instance at SSMS by manually.
Now see if we stop the browser services then we will not connect with named instance and give the error.
If we start the SQL Server browser services then we will connect through named instance at SSMS by manually.
Now you have to see when you start the SQL Server browser services then it will connect through named instance at SSMS by manually.
Use of SQL Server Browser Service
It listen all the incoming request which come for server resources and provide information about SQL instances that are installed on the machine.
Below are the task of SQL Server browser:
1. Browsing the available SQL Servers.
2. Connect to the correct SQL instance.
3. Connect to DAC (Dedicated Admin Connection)
No comments:
Post a Comment
If you have any doubt or question, please contact us.