BUG: Active/Passive Cluster Setup Breaks Replication and DTS

• Microsoft SQL Server version 7.0

SYMPTOMS

When replication is set up on an active/passive cluster and the SQL server instance fails over from the primary node of the cluster to the secondary node, replication distribution tasks running on the failover node (secondary node) of the cluster might fail with an error message:

could not obtain license information

CAUSE

If an active/passive cluster is set up, SQL server is installed only on the primary node of the cluster. Therefore, the license information is local to the primary node and, when failover takes place, the secondary node, which does not have license information for SQL server 7.0, cannot validate the replication scenario and see whether "per seat" or "per server" license mode is set.

WORKAROUND

In order to overcome this problem, the registry replication feature in the NT clustering can be used as follows:

1. Make sure that SQL server is running on the primary node of the cluster.



2. Open the cluster administrator and connect to the NT cluster and open the SQL cluster group.



3. Pick the Registry replication tab from the Properties view of "generic SQL server service" and add the following registry to be replicated:



SYSTEM\CurrentControlSet\Services\LicenseInfo\MSSQL7.00

Failover the SQL group on the cluster administrator to secondary node and note that the registry changes should be propagated to the secondary node.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

In an active/active cluster setup for replication/DTS to work between Enterprise and desktop/MSDE edition in case of failover, both nodes of the cluster should have SQL server 7.0 set to "per seat" licensing mode. This needs to occur even though replicating LicenseInfo registry key between the nodes is not required because licensing info is already available on the second node of the cluster by virtue of active/active setup.

Additional query words:

Keywords : kbSQLServ kbSQLServ700 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug