Security Manager 6.5 Reporting server will not install (NETIQKB72055)

  • Document ID:7772055
  • Creation Date:25-Jan-2010
  • Modified Date:12-May-2010
    • Micro Focus Products:
      Security Manager

Environment

Security Manager 6.5

SQL server 2005

Situation

When trying to install security manager 6.5 reporting component, there is a popup error message stating "ad hoc update to system catalogs is not supported" and the install fails.

The installation of a Reporting Server for Security Manager 6.5 will not complete

Resolution

Run the following SQL command and it will allow the install to finish.  After the reporting server install has successfully completed, reset the allow updates back to 1 by running the same command except replace the sp_configure ?allow updates, 0;   with  sp_configure ?allow updates, 1; .

 

exec sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'allow updates, 0;

GO

RECONFIGURE WITH OVERRIDE;

GO

Cause

The "allow updates" option within SQL 2005 has been set to 1 (this is obsolete in SQL 2005 and causes the error you are seeing)

Additional Information

Formerly known as NETIQKB72055