Menu
I can't start the SQL Server browser from SQL Service Configuration Manager 2008 version. There are absolutely no options to start the service. It's disabled as image shown below. How should I start the service again?
920
To start SQL Server Browser ServiceRight-click SQL Server Browser, and then choose Properties. On the Service tab of the SQL Server Browser dialog box, set the Start mode to Automatic. Choose OK to return to the SQL Server Configuration Manager main page. Right-click SQL Server Browser again, and then choose Start.
Answers. It is a security best practice to not run the SQL Server Browser service by default, as it reduces the attack surface area by eliminating the need to listen up on an udp port.
If SQL Server Browser service is stopped and IP along with port number is not provided then connection will be refused. If SQL Server instance is configured using dynamic ports then browser service is required to connect to correct port number.
To verify the SQL Server or SQL Server Express Browser Service is running: Open SQL Server Configuration Manager. In the left pane, select the SQL Server services. In the right pane, ensure that SQL Server Browser is set to Running.
If it is disabled, go to Control Panel->Administrative Tools->Services, and look for the SQL Server Agent. Right-click, and select Properties From the Startup Type dropdown, change from Disabled to Automatic.
196
Make sure that you run the SQL Server Configuration Manager snap-in as Administrator if UAC is enabled. Then right click the service and then click properties, change the start mode to enabled, then start it.
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
