Environment
NetIQ Group Policy Guardian 2.0
Resolution
fact
NetIQ Group Policy Guardian 2.0
symptom
GroupPolicyGuardian fails with error: 'System.Runtime.InteropServices.SEHException: External component has thrown an exception.'
symptom
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace.
symptom
Stack Track: [SEHException (0x80004005): External component has thrown an exception.]
cause
The account specified for GPG reporting during the install does not have the appropriate SQL permissions to bring up the initial reporting page. This is typically a result of the reporting account not having permissions to the
fix
Grant the GPG reporting logon permissions to the
NetIQ Group Policy Guardian 2.0
symptom
GroupPolicyGuardian fails with error: 'System.Runtime.InteropServices.SEHException: External component has thrown an exception.'
symptom
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace.
symptom
Stack Track: [SEHException (0x80004005): External component has thrown an exception.]
NetIQ.GPG.ReportSupport.ReportEngine.IsDotNetServerCompatibleWithDBRegConnStr(Byte[] strError, Int32, nBufferSize) +0
NetIQ.GPG.ReportSupport.ReportEngine.get_IsCompaibleWithDb() +69
Report.ADAudit.Page_Load(Object sender, EventArgs e) +73
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive()
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
cause
The account specified for GPG reporting during the install does not have the appropriate SQL permissions to bring up the initial reporting page. This is typically a result of the reporting account not having permissions to the
fa_aud_get_db_version
stored procedure.fix
Grant the GPG reporting logon permissions to the
fa_aud_get_db_version
stored procedure. - Launch SQL Enterprise Manger.
- Connect to the GPG database server.
- Expand the
FA_GP_AUDITING
database. - Expand Stored Procedures.
- Double-click the fa_aud_get_db_version stored procedure.
- Click Permissions.
- Select the EXEC check box for the FaAuditingReportUsers database role.
- Close the
fa_aud_get_db_version
stored procedure. - Close SQL Enterprise Manager.
Additional Information
Formerly known as NETIQKB49020