The account used to write the collected audit data to the Audit Database must be granted Database owner (db_owner) role and the dbcreator server role on specified SQL Server instance.
To assign the dbcreator and db_owner roles
On the computer where SQL Server instance with Audit Database resides, navigate to Start → All Programs → Microsoft SQL Server → SQL Server Management Studio.
- Connect to the server.
In the left pane, expand the Security node. Right-click the Logins node and select New Login from the pop-up menu.
- Click Search next to Login Name and specify the user that you want to assign the db_owner role to.
- Select Server roles on the left and assign the dbcreator role to the new login.
Select the User Mapping tab. Select all databases used by Netwrix Auditor to store audit data in the upper pane and check db_owner in the lower pane.
NOTE: If the account that you want to assign the db_owner role to has been already added to SQL Server Logins, expand the Security → Logins node, right-click the account, select Properties from the pop-up menu, and edit its roles.