Sql-server – SQL Server Browser: Why is it disabled

sql server

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?

Best Answer

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

Related Solutions

Firewall – Remote connection sql server not working but if firewall disabled it does

Probably you forgot to execute this command:

 netsh firewall set portopening TCP 1433 "SQLServer"

You could try out the new "Fix it" feature of this Microsoft support article: How do I open the firewall port for SQL Server on Windows Server 2008?

The page also contains a script, delete the lines, if you don't need SQL Service Broker, debugger, https etc.

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 

...

netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

Sql-server – Permissions required for an SQL Server account

See http://support.microsoft.com/kb/283811

Best Answer

Related Solutions

Firewall – Remote connection sql server not working but if firewall disabled it does

Sql-server – Permissions required for an SQL Server account

Related Topic