This section lists the requirements for the accounts used by DDC Provider. The accounts must be granted the following rights and permissions:
- A member of the local Administrators group on the computer where Netwrix Auditor Server and DDC Provider are installed.
- The Database datareader server role must be assigned to the account on the SQL Server instance where the DDC Collector database resides.
NOTE: Netwrix recommends using different accounts to connect to the SQL Server instances where DDC Collector database and Categories database reside.
Review the following for additional information:
On the computer where SQL Server instance with DDC_Collector_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.
- Select User mapping on the left and select the DDC_Collector_database for which you want to assign the role.
- In the Database role membership for: DDC_Collector_database list, select the db_datareader role.