Registering the SQLcompliance Agent Service with the Microsoft Cluster Administrator allows the Microsoft Cluster Service to manage the SQLcompliance Agent Service in failover situations. This configuration ensures the SQL trace continues to be audited during a failover and no audit data is lost.
Complete the following procedure on one cluster node hosting the virtual SQL Server instance. You can perform this task on the currently active node or on any passive node in the same cluster. The Microsoft Cluster Administrator tool replicates your completed configuration to the remaining nodes in the cluster.
To register the SQLcompliance Agent Service:
- Log on to the cluster node using an administrator account.
- If this is a Windows Server 2003 cluster , start the Microsoft Cluster Administrator tool. If this is a Windows 2008 or later cluster , start the Microsoft Failover Cluster Administrator tool.
- Add the SQLcompliance Agent Service as a generic service.
Specify the following dependencies:
- Disk where the SQLcompliance Agent trace directory is located
- SQL network name
- SQL Server
Specify the following generic service permissions:
- Specify a friendly name for the generic service.
- Specify the name of the SQLcompliance Agent Service (as displayed in the Services Manager tool), but leave the parameters unspecified. Use the SQL Compliance Manager Agent Details window in the Cluster Configuration Console to copy the service name to your clipboard. Paste the name in the provided field.
- Clear the start parameter setting.
- Select to use the network name.
Agree to replicate registry entries, and then specify the registry key for the SQLcompliance Agent Service. Use the SQL Compliance Manager Agent Details window in the Cluster Configuration Console to copy the registry key path to your clipboard. Paste the name in the provided field.
- Bring the generic service online.
- Ensure the SQLcompliance Agent is running on the active cluster node.