What SQL permissions does the DRA Service account require? (NETIQKB72667)

  • Document ID:7772667
  • Creation Date:05-Nov-2010
  • Modified Date:03-Nov-2011
    • Micro Focus Products:
      Directory and Resource Administrator

Environment

Directory and Resource Administrator 8.5
Directory and Resource Administrator 8.6

Situation

What SQL permissions does the DRA Service account require?

What are the minimum SQL permissions needed for the DRA Service Account?

Does the DRA Service Account need to be a SQL system admin?

Resolution

In order to configure and install the Netiq Reporting Center for DRA, the account used to install must have Sysadmin rights assoicated with it's SQL Server Login Account. The setup for reporting on SQL Server hosting the Netiq Reporting Center wiill need to be completed as well as the configuration of the reporting from the DRA Delegation and Configuration console. Once everything has been installed and configured, the access account specfied in the DNC console will need DB_owner on the following SQL DBs:

SMCubeDepot

DraReportting

Acf_configuration

Additional Information

Formerly known as NETIQKB72667