Cannot start SQLBrowser

Hi all,

Have a sql 2005 x64 sp2 2 node a/p cluster setup.

On both nodes it's not possible to start sqlbrowser service.

Compared registry and configuration on a 2nd equal system found no differences :-(

In eventlog I get:

Warning: The configuration of the SQL instance MSSQLServer is not valid.

Warning: The configuration of the SQL instance MSSQLSERVER is not valid.

Error: The SQLBrowser service was unable to establish SQL instance and connectivity discovery. Data: 0000: 08 00 00 00

Info: The SQLBrowser is enabling SQL instance and connectivity discovery support.

Warning: The configuration of the SQL instance MSSQLServer is not valid.

Info: The SQLBrowser service has started.

Info: The SQLBrowser service has shutdown.

Any help is highly appreciated.

TIA

acki

Hi,

Is your sql server browser service starting with a domain service accout?

|||

Yes, it's a domain account

Currently it is not into local admin group, but adding does not help.

|||

OK,

I tried to start sqlbroswer.exe manualy (sqlbrowser.exe -c) and getting the following output:

SQLBrowser: starting up in console mode

SQLBrowser: starting up SSRP redirection service

SQLBrowser is successfully listening on 0.0.0.0[1434]

SQLBrowser: failed starting SSRP redirection services -- shutting down.

Does this make someone flashing a light ?

TIA

Dan

|||

I am facing the same issue. Does anyone found a sloution for this problem?

Thanks

-Vikas

|||I've got the same problem...I've found a way to start SQLBrowser.

1. Bring offline SQL group(s) with Cluster Administrator
2. Delete on both cluster nodes these keys under Wow6432Node:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1]
and eventually
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.2]
if you have two instances.
3. Start SQLBrowser on both cluster nodes.
4. Bring online SQL group(s)

Anyway it's not a great solution everytime you bring online SQL Server service these keys under Wow6432Node are recreated and SQLBrowser doesn't start.

Hope it helps...

Alessandro