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:

To assign the Database datareader server role

  1. On the computer where SQL Server instance with NDC_SQL_Database resides, navigate to Start All Programs Microsoft SQL Server SQL Server Management Studio.

  2. Connect to the server.
  3. 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.

  4. Select User mapping on the left and select the NDC_SQL_database for which you want to assign the role.

  5. In the Database role membership for: NDC_SQL_database list, select the db_datareader role.