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