I cannot start SQL Server browser

Question

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?

Solution 1

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.

Solution 2

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.

Solution 3

My approach was similar to @SoftwareFactor, but different, perhaps because I'm running a different OS, Windows Server 2012. These steps worked for me.

Control Panel > System and Security > Administrative Tools > Services, right-click SQL Server Browser > Properties > General tab, change Startup type to Automatic, click Apply button, then click Start button in Service Status area.

Solution 4

Clicking Properties, going to the Service tab and setting Start Mode to Automatic fixed the problem for me. Now the Start item in the context menu is active again.

Solution 5

go to Services, find SQL Server Browser, right click --> Properties --> General tab --> Startup Type --> select automatic . Then go back to configuration management, start it.

View more solutions

Comments

[Martin Smith]

If you choose Properties can you change the start mode to something other than disabled? e.g. automatic and then start it?

[Nipun Alahakoon]

no its also not possible something like error 1058 appear

[BenR]

What should I if starting SQL Server Agent is also grayed out?

[EJ Mak]

The question was regarding SQL Server Browser, not the Agent.

[Kyle Strand]

@EJMak The same process appears to work for the browser.

[Zach Smith]

I get an error The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. [0x80070422]

[Christofer Ohlsson]

It is already "Automatic" for me, but I still have OP's problem.

[Simon Lang]

@ChristoferOhlsson "Automatic" referes to the "Startup Type". Check the "Status" of the service, which should be "Running".

[David Jones]

I did that from SQL Server Config Manager

[Mohsin AR]

@BenR make sure you are login with administrator user