Cluster Service Receives Error 1024 with SNMP Installed with SQL Server 7.0 (301964)

The information in this article applies to:

Microsoft Windows 2000 Advanced Server SP1
Microsoft Windows 2000 Advanced Server SP2
Microsoft SQL Server 7.0

This article was previously published under Q301964

SYMPTOMS

During a Move Group or Failover operation in Microsoft SQL Server 7.0 on Windows 2000 Advance Server running SNMP, event ID 1024 is posted:

Event ID: 1024
The registry checkpoint for cluster resource "virtual SQL name" SQL server 7 could not be restored.
The resource may not function correctly.

CAUSE

The registry key for that resource is in use. More specifically, the key is still open by the RegRestoreKey function and returns ERROR_ACCESS_DENIED.

RESOLUTION

To resolve this problem, obtain the latest service pack for Windows 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

260910 How to Obtain the Latest Windows 2000 Service Pack

The English version of this fix should have the following file attributes or later:

   Date        Time      Version        Size        File name
   -------------------------------------------------------------
   7/20/2001   07:04p   5.0.2195.3904   1,685,696   Ntkrnlmp.exe
   7/20/2001   07:05p   5.0.2195.3904   1,685,312   Ntkrnlpa.exe
   7/20/2001   07:05p   5.0.2195.3904   1,705,984   Ntkrpamp.exe
   7/20/2001   07:04p   5.0.2195.3904   1,663,424   Ntoskrnl.exe

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Windows 2000 Service Pack 3.

MORE INFORMATION

For additional information about how to install Windows 2000 and Windows 2000 hotfixes at the same time, click the article number below to view the article in the Microsoft Knowledge Base:

249149 Installing Microsoft Windows 2000 and Windows 2000 Hotfixes

Modification Type:	Minor	Last Reviewed:	9/26/2005
Keywords:	kbHotfixServer kbQFE kbbug kbfix kbOSWin2000fix kbWin2000PreSP3Fix kbWin2000sp3fix KB301964