Page History

...

1. Open Server Manager.
2. In the Server Manager tree, click Server Manager > Features > Failover Cluster Manager. The system displays Failover Cluster Manager.
3. Take the cluster service agent SQLcomplianceAgent$[listener name] offline by selecting the service in the tree, clicking the cluster service agent in the Other Resources area, and then clicking Take this resource offline in the Actions panel. Verify in the confirmation message that you want to take the resource offline. In the following example, SQLcomplianceAgent$AOAGLISTENER is the now offline cluster service agent.
   
4. Keep Failover Cluster Manager open as you will return to this view after removing the listener from SQL Compliance Manager.
5. Open the SQL CM Management Console.
6. Click the listener name in the Explore Activity panel, and then click Remove.
   
   SQL Compliance Manager displays an error message concerning the inability to contact the agent when removing the listener.
   
7. Click Yes to confirm that you want to continue with removal of the instance.
8. After removing the listener in SQL Compliance Manager,
9. .
10. If you want to re-add this listener for auditing at a later time, do not continue with the next steps. If you no longer want to use this listener, continue with the following steps for all nodes included in the AlwaysOn Availability Group.
11. Return to Failover Cluster Manager.
12. Delete the cluster service agent SQLcomplianceAgent$[listener name] by selecting the service in the tree, clicking the cluster service agent in the Other Resources area, and then clicking Delete in the Actions panel. Verify in the confirmation message that you want to delete the resource. In the following example, SQLcomplianceAgent$AOAGLISTENER is the cluster service agent.
    Image Added
    The following example shows that the resource is now gone after deletion.
    Image Added
13. Open the Cluster Configuration Console by clicking Start > Idera > Cluster Configuration Console.
14. Select the virtual SQL Server listener, and then click Remove Service. In the following example, AOAGLISTENER is the listener.
    Image Added
15. Click Yes in the confirmation message. The cluster service agent is removed.
16. If you no longer need to add listeners, uninstall the Cluster Configuration console.test

SQL Compliance Manager audits all activity on your server. Learn more > >