The SQL Compliance Manager Agent Service Account tab of the Add SQL Compliance Manager Agent Service wizard lets you specify the account credentials the SQL Compliance Manager Agent Service account should use to connect to the Collection Server and the virtual SQL Server. The SQL Compliance Manager Agent Service also uses this account to stop and start SQL Server traces, execute stored procedures, and manage trace files. Ensure you specify a valid Windows account that has the following permissions:

  • SQL Server System Administrator privileges on the target virtual SQL Server
  • Administrator permissions on each node in the cluster hosting the virtual SQL Server
  • Read and write access to the trace directory you specify

Specify the account the SQL Compliance Manager Agent Service should run under, and then click Next.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels