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
