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?

window

If you choose Properties can you change the start mode to something other than disabled? e.g. automatic and then start it? — Martin Smith, Jan 27 '14 at 09:08

score 205 · Answer 1 · edited Aug 31 '19 at 17:03

205

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.

edited Aug 31 '19 at 17:03

Lahiru Mirihagoda

1,113
1
16
30

answered Apr 25 '14 at 03:27

user3571376

2,067
1
11
3

8

What should I if starting SQL Server Agent is also grayed out? – BenR Sep 12 '14 at 19:43
15

The question was regarding SQL Server _Browser_, not the Agent. – EJ Mak Sep 13 '14 at 18:09
7

@EJMak The same process appears to work for the browser. – Kyle Strand Oct 23 '14 at 23:44
It is already "Automatic" for me, but I still have OP's problem. – Christofer Ohlsson Dec 14 '17 at 12:46
@ChristoferOhlsson "Automatic" referes to the "Startup Type". Check the "Status" of the service, which should be "Running". – Simon Lang Apr 10 '18 at 13:36
1

I did that from SQL Server Config Manager – David Jones Feb 05 '21 at 04:46
@BenR make sure you are login with administrator user – Mohsin AR Apr 29 '21 at 00:44

score 22 · Answer 2 · answered Jan 27 '14 at 10:19

22

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.

answered Jan 27 '14 at 10:19

steoleary

8,968
2
33
47

score 22 · Answer 3 · edited Oct 24 '17 at 09:06

22

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.

edited Oct 24 '17 at 09:06

Timeless

7,338
9
60
94

answered Sep 13 '14 at 18:07

EJ Mak

799
1
8
29

score 17 · Answer 4 · edited Jun 21 '16 at 14:08

17

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.

edited Jun 21 '16 at 14:08

Tony Hinkle

4,706
7
23
35

answered May 08 '14 at 18:45

SoftwareFactor

8,430
3
30
34

3

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]` – Zach Smith May 18 '17 at 18:46

score 13 · Answer 5 · answered Oct 26 '17 at 22:16

13

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

answered Oct 26 '17 at 22:16

Jailene Huang

173
1
6

score 2 · Answer 6 · edited Aug 23 '20 at 10:56

2

run > regedit > HKEY_LOCAL_MACHINE > SOFTWARE > WOW6432Node > Microsoft > Microsoft SQL Server > 90 > SQL Browser > SsrpListener=0

edited Aug 23 '20 at 10:56

clairestreb

1,243
12
24

answered Feb 02 '15 at 09:55

ehsan

21
1

score 2 · Answer 7 · answered Apr 01 '20 at 05:59

I'm trying to setup rf online game to be played offline using MS SQL server 2019 and ended up with the same problem. The SQL Browser service won't start. Almost all answers in this post have been tried but the outcome is disappointing. I've got a weird idea to try start the SQL browser service manually and then change it to automatic after it runs. Luckily it works. So, just simply right click on SQL Server Browser ==> Properties ==>Service==>Start Mode==>Manual. After apply the changes right click on the SQL Server Browser again and start the service. After the service run change the start mode to automatic. Make sure the information provided on log on as: are correct.

score 1 · Answer 8 · edited Oct 24 '17 at 09:07

1

right click on SQL Server browser and properties, then Connection tab and chose open session with system account and not this account. then apply and chose automatic and finally run the server.

edited Oct 24 '17 at 09:07

Timeless

7,338
9
60
94

answered Jul 06 '15 at 03:32

cmsdesigner

11
1

I cannot start SQL Server browser

8 Answers8

Linked