FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration (299362)

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.