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.
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