SQL Server Browser not working properly


A SQL Server 2005 cluster stopped answering on a named instance, I restarted many SQL Server Browser but it didn't solve...

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

C:\Program Files (x86)\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 a lot 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, now everything works !

We spent a lot of time troubleshooting this bad issue but we won !!!
Tags: , , ,

About author

Vittorio Pavesi