What is the purpose of the DRAReporting.msi file and where does it need to be executed? (NETIQKB72562)

  • 7772562
  • 27-Aug-2010
  • 27-Aug-2010

Environment

Directory & Resource Administrator 8.5
Directory & Resource Administrator 8.5 SP1
Directory & Resource Administrator 8.6

Situation

What is the purpose of the DRAReporting.msi file and where does it need to be executed?

Resolution

The DRAReporting.msi file should be executed on the designated machine running SQL to be used for DRA Reporting.  This can be a local or remote SQL server, however, the file itself cannot be run remotely.  If you have chosen to install DRA Reporting and the SQL server is not local to the DRA install, you will need to run this file locally on the SQL machine.

DRAReporting.msi does the following:

  • Creates the SMCubeDepot database in SQL.
  • Import the SSIS packages into SQL Server Integration Services. These get created as jobs in SSIS, which can subsequently be enabled and configured from the Reporting configuration wizard in the Win32 console.

 

Additional Information

Formerly known as NETIQKB72562