During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection services -- shutting down". Does anybody have an idea how this problem could be fixed?
Asked
Active
Viewed 1,446 times
1 Answers
1
This issue can be caused by an old version of SQL Server 2000 that was improperly removed.
In summary, SQL Browser is a replacement for the SSRP redirection service. If you no longer have SQL 2000 on your computer, check the registry for a key named "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\CurrentVersion". If it is there, rename it to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\CurrentVersion_old". There may be an additional, similar key at "HKLM\SOFTWARE\WOW6432\Microsoft\MSSQLSERVER", so you should check there too. Once you have changed the registry, see if you can start the SQL Browser service.
See this MSDN blog entry for details.
Darin Strait
- 2,012
- 12
- 6