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
SQLBrowser: failed starting SSRP redirection services -- shutting down.
I found the following workaround working for me, but just temporary.
The problematic registry key was:
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).
Change current Registry key name
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.