You can specify the accounts that are allowed to access the audit store database. By configuring these accounts, you can control which collector computers can connect to the audit store database and which management databases have access to the data stored in the audit store database.
Your account must have Manage SQL Login permission to configure the incoming accounts.
To configure allowed accounts:
- Open Audit Manager.
- Expand the installation node, then expand Audit Stores and select a specific audit store name.
- Select a database under the audit store, right-click, then select Properties.
- Click the Advanced tab.
- Click Add to add a collector or management database account. For example:
- Select an authentication type.
If you select Windows authentication, you can browse to select a computer, user, or group to add.
If you select SQL Server authentication, you can select an existing SQL Server login or create a new login.
Connections should use Windows authentication whenever possible. However, computers in an untrusted forest cannot connect to an audit management database using Windows authentication. To allow connections from an untrusted forest, add a SQL Server login account as the incoming account for the management database.