none
Cannot start SQLBrowser RRS feed

  • Question

  • 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

     

     

    Thursday, April 19, 2007 8:06 AM

All replies

  • Hi,

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

    Thursday, April 19, 2007 8:36 AM
  • Yes, it's a domain account

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

     

     

    Thursday, April 19, 2007 8:52 AM
  • 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

    Tuesday, April 24, 2007 7:31 AM
  • I am facing the same issue. Does anyone found a sloution for this problem?

     

    Thanks

    -Vikas

     

    Tuesday, July 31, 2007 8:31 PM
  • 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








    Thursday, August 2, 2007 10:01 AM