[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Browser Service won't start

Posted on 2009-04-23
5
Medium Priority
?
2,740 Views
Last Modified: 2012-05-06
Hi:

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 0.0.0.0[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
Server\MSSQL.4\MSSQLServer

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
Server\MSSQL.4\MSSQLServer

TO

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL
Server\MSSQL.4\MSSQLServer_x

==========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.

Thanks

0
Comment
Question by:it-support-at
  • 3
  • 2
5 Comments
 
LVL 57

Expert Comment

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

http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx
0
 

Author Comment

by:it-support-at
ID: 24218757
There was never a 32bit SQL installed on this cluster. That is the difference from the workaround.
0
 

Author Comment

by:it-support-at
ID: 24218849
The environment did run without problem for more then 2 years ...
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24221821
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).
0
 

Accepted Solution

by:
it-support-at earned 0 total points
ID: 24371896
System has been reinstalled.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

830 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