For NDC Provider
This section lists the requirements for the account used by NDC Provider. The account must be granted the following rights and permissions:
- The Database datareader server role must be assigned to the account on the SQL Server instance where the NDC SQL database resides.
NOTE: Netwrix recommends using different accounts to connect to the SQL Server instances where NDC SQL database and Categories database reside.
Review the following:
On the computer where SQL Server instance with NDC_SQL_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 and click OK.
Select User mapping on the left and select the NDC_SQL_database for which you want to assign the role.
In the Database role membership for: NDC_SQL_database list, select the db_datareader role.