SQL Browser Service won't start

Posted on 2009-04-23
Last Modified: 2012-05-06

I have issue starting SQL Server Browser service on a SQL 2k5 Win2003 x64 machine. when I start it from the services applet in control panel, I get the following error message:

The SQL Server Browser service on Local computer started and then stopped.

I tried starting it from the surface area configuration tool as well but could not start. I also tried to start sql browser from the command prompt using the sqlbrowser.exe -c. I get the following message:

C:\Program Files\Microsoft SQL Server\90\Shared>sqlbrowser.exe -c
SQLBrowser: starting up in console mode
SQLBrowser: starting up SSRP redirection service
SQLBrowser is successfully listening on[1434]
SQLBrowser: failed starting SSRP redirection services -- shutting down.

I found the following workaround working for me, but just temporary.

==========WORKAROUND START===========

The problematic registry key was:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL

The Wow6432Node part of the registry should be only for 32 bit applications. This key was empty but the mere presence of the key confused the sqlbrowswer
service since it was listed as mssql.1 as was the correctly installed 64-bit instance.

Precise resolution would be to remove the above registry key (assuming there is no 32 bit install on the box).

to resolve:

Change current Registry key name

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL


HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL

==========WORKAROUND END===========

This workaround works but each time the node is restarted these entries are rebuilt and the issues persist again. Do we know what application creates these entries and how this can be fixed permanently.. This would be helpful to understand what's going wrong and how we could fix it too permanently.

Any help is really appreciated.


Question by:it-support-at
    LVL 57

    Expert Comment

    by:Raja Jegan R
    This should help you out in your proper configurations:

    Author Comment

    There was never a 32bit SQL installed on this cluster. That is the difference from the workaround.

    Author Comment

    The environment did run without problem for more then 2 years ...
    LVL 57

    Expert Comment

    by:Raja Jegan R
    If it was working without problems for the last 2 years then what is the recent configuration change done to the system like any one of the below:

    1. Change is host name or system name
    2. Change in user accounts of any services involved.
    3. Password reset or expired for any of the accounts involved.
    4. IIS reset or changes done.
    5. Or any other recent configurations to the system( which you are aware in that machine).

    Accepted Solution

    System has been reinstalled.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now