Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am attempting to start SQL Server Browser through the SQL Server Configuration Manager. However, not only is the "state" of SQL Server Browser stopped, but the options to Start, Stop, Pause, Resume, and Restart are all disabled (both in the right-click context menu, and through the Properties dialog).

(Also, in the Properties dialog, I have attempted all 3 options for "built-in account": Local System, Local Service, and Network Service. I have also attempted "This Account" with various options. In all cases, the functionality remains disabled.)

I initially thought it might be a port issue. Apparently, SQL Server Browser uses Port 1434. However, using a program called CurrPorts, I find that Port 1434 is not being used by any program.

Can anyone help?

share|improve this question

1 Answer 1

up vote 10 down vote accepted

The service itself is disabled by default. In SQL Server Configuration Manager, go to Properties -> Service tab -> Start Mode = Automatic.

share|improve this answer
1  
You are on a roll today –  Mark Henderson Apr 25 '12 at 22:41
    
Thank you, sir. :) –  Joel E Salas Apr 25 '12 at 22:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.