The SQLcompliance Agent Trace Directory tab lets you specify which folder should be used for the SQLcompliance Agent trace directory. The SQLcompliance Agent stores SQL Server trace files in this directory until the files can be sent to the Collection Server for processing. The specified folder must be located on a shared data disk for the specified virtual SQL Server. Ensure you specify the same directory path for each node in the cluster hosting the virtual SQL Server.

You can specify an existing folder or a new folder that the Cluster Configuration Console will create for you. When the Cluster Configuration Console creates the trace directory, the directory is secured using ACL settings. Only local administrators have read and write access to the new folder. Ensure the SQLcompliance Agent Service account has read and write privileges on that folder. The Cluster Configuration Console does not change the security settings on existing folders.

Specify the folder where the SQLcompliance Agent should store SQL Server trace files, and then click Next.

 

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