SM reporting component will not install (NETIQKB70746)

  • Document ID:7770746
  • Creation Date:02-Nov-2007
  • Modified Date:31-Dec-2007
    • Micro Focus Products:
      Security Manager

Environment

Security Manager 6.0
Security Manager Reporting 6.0

 

The SQL database is installed on a cluster.  (64 bit)

The SQL Analysis and integration components are installed on another non-clustered 64 bit box.

The SM Reporting component is being installed on the Analysis/Integration box.

Situation

Failed to validate SQL Server Integration Services Instance Name (Instance Name) because of the following error:
ValidateDatabase: FAILED.

Resolution

To resolve this issue and complete the Reporting Component installation, modify the Windows Registry as detailed below:

  1. Click Start - Run and Type regedit.
  2. Expand HKLM\SOFTWARE\WoW6432Node\Microsoft\Microsoft SQL Server\90\DTS\Setup.
  3. In the right hand pane double-click the Version value name.
  4. Change the value data to 9.2.3042.00
  5. Click OK and close regedit.
  6. Run the Security Manager Reporting Server installation

 

Cause

The verification step is looking for the SSIS version information in:

HKLM\SOFTWARE\WoW6432Node\Microsoft\Microsoft SQL Server\90\DTS\Setup\Version.  (This is the value to query in order to validate a *32-bit* version of SSIS running on 64-bit Windows).  The correct registry value to query to verify the version of a 64-bit version of SSIS running on 64-bit Windows is: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup\Version (not WoW6432Node).

Additional Information

Formerly known as NETIQKB70746

Warning: Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. NetIQ Technical Support cannot guarantee that problems resulting from the incorrect use of Registry Editor can be resolved. Make sure you back up your registry prior to making any changes.