Error: Crystal report viewer: error detected by database dll. when opening a completed report in V (NETIQKB39144)

fact
VigilEnt Security Manager 4.0

fact
VigilEnt Security Manager 4.1

symptom
Error: 'Crystal report viewer: error detected by database dll'  when opening a completed security checkup report.

cause
Stored procedures do not have the correct permission for database roles VigilEntAccess, VigilEntUserAccess, and VigilEnt_Users.

fix

To resolve this error, please refer to the following:

1. In SQL Enterprise Manager, select the VigilEnt Database.  
2. Select Stored Procedures.
3. Scroll down and find sp_createChecksSummary, select it, right-click and choose Properties.
4. Click Permissions.
5. Verify that VigilEntAccess, VigilEntUserAccess, and VigilEnt_Users are selected in the EXEC column.  If a check mark does not exist in the EXEC column for those roles, put one there.
6. Repeat steps 3 and 4 for the following stored procedures:
   
   
• sp_CreateGroupMembersSummary
• sp_CreateGroupsSummary
• SPGETSCTTEMPLATE
• SPGETSCTVERSION
• sp_t_SecurityCheckup_Print1

Formerly known as NETIQKB39144