When trying to view an IT Analytics report, the error "Access Denied" occurs.
Different IT Analytics (ITA) and Microsoft SQL Server Report Server (SSRS) configuration settings can result in this issue. The following steps walk the user through checking various areas that can be an issue.
- In the Symantec Management Platform Console, click on the Settings button > Notification Server > IT Analytics Settings.
- Click on Configuration.
- In the Reporter Server section, in the Authentication Type field, it is recommended that this is set to Stored Credentials. This user account must have full access to be able to use SSRS. Optimally, the account used by the Reporting Services Configuration Manager for the Service Account should be used. If it is known that this user (while logged in as such) works, but others do not, this is especially true. If a different account is desired to be used but does not work, please contact your DBA for assistance in configuring SSRS security. Note: If Windows Integrated Security, works, however, verify which account was used and then the DBA or network administrator will need to be contacted to determine what the differences are between this Windows account and the desired Windows account's permissions.
- Click on the Save Security Settings button if any changes were made.
- Click on Reports.
- Click on the Security tab.
- If the user is not added here, add them.
- Click on the Save Changes button if any changes were made.
- The user may be in the wrong Altiris Security Role. ITA users must be in at least the IT Analytics Users and as a minimum, also in the Symantec Guests roles. More information about this can be found here:
Error "Access Denied" occurs when trying to use the Symantec Management Platform 7.1 Console while using the IT Analytics Users security role
- In the Report Manager (http://<ssrs server name>/Reports), if the user cannot access this at all, this is also likely due to permission issues but are entirely on the SSRS and have nothing to do with ITA. Please contact your DBA for assistance in configuring SSRS security.
- If the user can access Report Manager, however, or a different user can, this can then be used to check report security. Click to open the IT Analytics report folder.
- Highlight the IT Analytics data source and click on Manage.
- Under the "Connect using" section, this should be set up the same as step 3. If not, change it to be so.
- Click on the Test Connection button. If this fails, contact your DBA for further assistance.
- Click on the Apply button once the Test Connection button works.
- Repeat steps 12 through 15 for the CMDB data source.
- If all of this is configured but reports still cannot be accessed, verify if these are able to be while on the Symantec Management Platform server or on the SSRS. If so, then Microsoft Kerberos may need to be next installed to enable the network authentication to continue past three hops. Information about this can be found here:
Does IT Analytics work with Microsoft Kerberos?