Resolution
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
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:
- In SQL Enterprise Manager, select the VigilEnt Database.
- Select Stored Procedures.
- Scroll down and find sp_createChecksSummary, select it, right-click and choose Properties.
- Click Permissions.
- 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.
- Repeat steps 3 and 4 for the following stored procedures:
- sp_CreateGroupMembersSummary
- sp_CreateGroupsSummary
- SPGETSCTTEMPLATE
- SPGETSCTVERSION
- sp_t_SecurityCheckup_Print1
Additional Information
Formerly known as NETIQKB39144