This article describes key requirements to ensuring a successful configuration of the SQL Report Server Integration with AVG Managed Workplace.
Please note: if you are not familiar with SQL Server Reporting Services please see Microsoft’s documentation on the subject.
Below are the verification steps to ensure a successful configuration of SQL Server Reporting Services integration with AVG Managed Workplace when running separate servers for the Service Center application and database.
In order for the Service Centers Report server integration to work, the 4 following items must be accessible on the SQL Report Server from the Service Center application server:
The account used during the Report Server configuration must have administrative access to the Report Server machine and Report Manager web site. An SQL account cannot be used for this part of the configuration and this account must be a computer user or domain user account. The account used for this is not stored in the service center database, but instead is used to create a limited user account (MWSCReportUser) used only for the Report Server integration.
Before running the Reporting Configuration, the the Report Manager URL must be accessible. The Service Center will rely on this URL for publishing delivery schedules and other reporting tasks. This URL will vary depending on whether a customer instance name or not is used during the Reporting Services installation. This URL is located by logging into the Report Server and performing the following steps:
If the Report Manager URL is not accessible, you may need to check some of the following items:
Before you can run the Reporting Configuration, you must be able to access file shares (hidden or published) on the Report Server from the Service Center application server. File sharing is used to transfer report files to the report server when installing new reports. During the reporting configuration, and additional share will be created called MWResources.
Before you can run the Reporting Configuration you must be able to query WMI on the Report Server from the Service Center application server. The Reporting Configuration relies on WMI access to help detect the installed SQL Server Reporting Services version as well as the correct instance name. To verify WMI is accessible, perform the following steps:
For SQL 2008 or 2008 R2
For SQL 2012
For SQL 2014
You should see something similar to the following: