Before you start creating a monitoring plan to audit your SQL Server, plan for the account that will be used for data collection – it should meet the requirements listed below. Then you will provide this account in the monitoring plan wizard.
On the target SQL Server:
To access SQL Server, Windows authentication will be used, so data collection account should be a Windows account specified in the domain\user format.
SQL Server logins and authentication method are not supported.
- The account must be assigned the System Administrator server role for this SQL Server. See Assigning 'System Administrator' Role for more information.