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 !!!
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 !!!
0 commenti:
Post a Comment