14 Day History report does not display in the Client Security console

When you open the Client Security console, you might notice the following message under 14 Day History report:

Error message
Microsoft Forefront Client Security cannot display this report. Confirm that the reporting server is available, the account name and password are correct, and the account has permissions to access the report.

There are two possible causes for this issue:

1- The user opening the Client Security console has not been granted Client Security Report Viewer permissions.

2- The SQL Server Reporting Services site needs to be added to the list of trusted sites.

To solve this issue, do the following.

To add the SQL Reporting Services site to the list of trusted sites
A. In Internet Explorer, on the Tools menu, click Internet Options.
B. Click the Security tab, and then click the Local intranet zone.
C. Click the Sites button.
D. In the Add this website to the zone box, type the URL of the SQL Server Reporting Services site. For example, http://servername.
E. Click Add, click Close, and then click OK for all subsequent dialog boxes.
F.Refresh the Client Security console.

Before using Client Security, you must grant additional permissions to the service accounts.

To grant the correct permissions for the service accounts

A. On the Client Security server, add the action account to the Administrators group.
B. Grant the reporting account db_owner permissions on the SystemCenterReporting database.
C. If you used different accounts for the DAS account and the action account, grant the action account db_owner permissions on the OnePoint database.
D. If you used different accounts for the DAS account and the reporting account, grant the reporting account db_owner permissions on the ReportServer database.

To grant permissions to SQL Server databases

A. On the server with the appropriate database (OnePoint or SystemCenterReporting), start SQL Server Management Studio.
B. In the console tree, expand Security.
C. Right-click Logins, and then click New Login on the shortcut menu.
D. In the Login dialog box, type the appropriate service account (domain\username) in the Login name box.
E. Under Select a page, click User Mapping, and then in the Map column, select the check box for (OnePoint, ReportServer and SystemCenterReporing) databases.
F. In the Database role membership box, select the db_owner check box, and then click OK.

If you have any qustion regarding this issue, please send your qustion to the following link:
http://forum.fourtyfivecorp.net/viewtopic.php?f=6&t=42

Best Regards
Abduljalil Abolzahab