Search

Wednesday, May 16, 2012

SQL Server Browser not working properly

Today my SQL Server cluster stopped answering on a named instance, I restarted SQL Server Browser but it didn't started.


So I started the process from console using -C argument in order to get more information.


C:\Program Files\Microsoft SQL Server\90\Shared>sqlbrowser.exe -c


I noticed that query against instance 1 generated CLNT_UCAST_INST and CLNT_BCAST_EX packets but query against instance 2 generated only CLNT_UCAST_INST packets.


I googled for this and then I found a post saying to delete this registry key:


[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.2], 
I did it and then I restarted service, and now my SQL server is running perfectly.



No comments:

Post a Comment