Microsoft KB Archive/193450

= BUG: Vsrvsvc.exe Causes Exception If Registry Keys Are Missing =

Article ID: 193450

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 6.5 Enterprise Edition

-



This article was previously published under Q193450



BUG #: 18243 (SQLBUG_65); 18242 (SQLBUG_65)



SYMPTOMS
The virtual server service (Vsrvsvc.exe) will cause a memory exception error at c0000005 on SQL Server 6.5 Enterprise Edition Clustered Servers if registry keys are missing or have become corrupted. No errors will be displayed in the SQL Server error log. Because the SQL Server service depends on Vsrvsvc.exe, the cluster manager will shut down the SQL Server service. This will appear as "Shutdown by request" in the SQL Server error log.



CAUSE
This error is caused during the release of an unallocated object when an undefined registry key is operated on (for example, SetValue/QueryValue and so on) through the virtual server service. This incorrect deallocation causes an access violation (AV) in Vsrvsvc.exe.



WORKAROUND
To repair the missing or invalid entries in the registry, you must reinstall Windows NT and SQL Server clustering. However, it is not necessary to remove the existing SQL Server installation or user databases. To do this, perform the steps below.

NOTE: Using the RegistryRebuild option of Setup will not rebuild the virtual SQL Server registry keys. This option should not be used to resolve this issue.


 * 1) Remove SQL Server clustering and then remove Windows NT clustering.
 * 2) Reinstall Windows NT clustering.
 * 3) Confirm the operation and that resources can be failed between the two nodes.
 * 4) Reinstall SQL Server clustering and confirm that the SQL Server resource group can be moved between the two cluster nodes.



STATUS
Microsoft has confirmed this to be a problem in SQL Server Enterprise Edition version 6.5.



MORE INFORMATION
The virtual server service, Vsrvsvc.exe, is used to communicate between the clustered virtual SQL Server and the host computer registry. This error will only occur if the SQL Server has been clustered, because this is the only time the Vsrvsvc.exe is used.

Additional query words: errorlog EE 6.5ee

Keywords: kbbug kbnofix KB193450

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.