Email notifications are not being generated when repository actions are performed. (NETIQKB52760)

  • Document ID:7752760
  • Creation Date:02-Feb-2007
  • Modified Date:05-Sep-2007
    • Micro Focus Products:
      Group Policy Administrator

Resolution

fact
NetIQ Group Policy Administrator 5.0

fact
You are only installing the GPA Server component

symptom
Email notifications are not being generated when repository actions are performed.

symptom

The following error is displayed in the GPA Server logs: "Could not connect to SQL DB. SQL Server is not same box as GPA Server. Exception: Cannot open database requested in login 'GPO_REPOSITORY'. Login fails. Login failed for user 'GPEUROPE\GpaServiceUser'."



symptom
Error: "failed to get transport configuration settings" when trying to use export override to deploy a GPO. 

cause

The installer does not create a login for the NetIQ GPA Server user account in the GPO_REPOSITORY database when performing a GPA Server component-only installation. Because of this the service account running the NetIQ GPA Server service is not granted the appropriate permissions to the GPO_REPOSITORY database and is not made a member of the NetIQ_GPR_Server role.



fix

Ensure the service account for the NetIQ Group Policy Administrator (GPA) server is granted Public permissions to the GPO_REPOSITORY database and is added to the NetIQ_GPR_Server role by performing the following steps:

  1. Launch SQL Enterprise Manager and connect to the database server that contains the GPO_REPOSITORY database.
  2. Expand the Security> Logins node and verify the GPA Security account is listed in the result window.
  3. If the GPA Security account is not listed in the result window, on the Action menu click New Login to add the GPA Security account.
  4. In the result window, click the GPA Security account.
  5. On the Action menu, click Properties.
  6. On the Database Access tab, select the GPO_REPOSITORY database.
  7. Confirm there is a check mark in the box next to GPO_REPOSITORY database in the Permit column.
  8. Confirm there is a check mark in the box next to public in the "Database roles for 'GPO_REPOSITORY'" window.
  9. Navigate to the Databases > GPO_REPOSITORY > Roles node.
  10. Select NetIQ_GPR_Server, and then on the Action menu click Properties.
  11. Confirm the GPA Security account is listed in the window titled "Database role type."
  12. If the GPA Security account  is not listed, click Add to add the the GPA Security account, and then click OK.


Additional Information

Formerly known as NETIQKB52760