Microsoft KB Archive/299362

= FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration =

Article ID: 299362

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Developer Edition

-



This article was previously published under Q299362



BUG #: 235394 (SHILOH_BUGS)



SYMPTOMS
In SQL Server 2000, an instance of the server along with any publications, databases or other objects it contains may be integrated with Active Directory (AD). The AD integration information for the instance is stored in the following registry keys:

Clustered or Nonclustered Default Instance

HKLM\Software\Microsoft\MSSQLServer\SQLServerSCP

Clustered or NonClustered Name Instance

HKLM\Software\Microsoft\Microsoft SQL Server\InstanceName\SQLServerSCP

When you register a virtual SQL Server server with the AD either through the GUI or by using the sp_activedirectory_scp stored procedure, the preceding registry keys are updated with the integration information. When a failover of the SQL Server virtual server occurs, the key is not copied over to the other node.

Because the current node does not have any information about the AD integration of the virtual server, users are not be able to view the database objects, or publications that were registered in the AD.

The SQL Server Active Directory service, MSSQLADHelper, is used for integration of SQL Server and it's objects with the Active Directory. This service, by default, runs under the Local System account and is started as needed when you add new SQL Server objects or you refresh AD information.



CAUSE
Setup fails to create the preceding registry key and during a failover, the registry key is not being replicated to the other node, when then causes AD integration issues.



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

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB299362

-

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

© Microsoft Corporation. All rights reserved.