Partner Support

English

X

Select your language:

How to successfully configure SQL Report Server Integration

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 for the configuration must have administrative access to the Report Server machine and Report Manager website
  • The Report Manager URL must be accessible
  • File Sharing must be accessible
  • WMI Must be accessible

Configuration Account

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.

Report Manager URL

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:

  1. Log into the server hosting SQL Server Reporting Services.
  2. Launch the Reporting Services Configuration Manager.
  3. On the Reporting Services Configuration Connection screen, choose the correct Report Server Instance.
  4. Click Connect.

    User-added image

  5. Click the Report Manager URL tab on the left.

    User-added image

  6. Make note of the URL displayed.
  7. Log into the Service Center application server.
  8. Launch Internet Explorer.

    User-added image

  9. Navigate to the URL noted in Step 6 (Example: http://mysqlserver/Reports).
  10. When prompted for credentials, enter the credentials for an account that has administrative access to the Report Manager URL.
    Grant User Access to a Report Server (Report Manager)
  11. You should see the following:

    User-added image

If the Report Manager URL is not accessible, you may need to check some of the following items:

  • The account has the correct permissions
  • The SQL Server Reporting Services service is running
  • There is no firewall blocking access to the Report Manager URL (Default port 80)

File Sharing

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.

WMI Access

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:

  1. Log into the Service Center application server.
  2. Go to Start > Search.
  3. Type wbemtest.exe and press enter to launch WBemTest.
  4. On the next screen, click Connect.

    User-added image

  5. In the Namespace field, enter the appropriate namespace. This will vary based on the SQL Version and Instance name. See Access the Reporting Services WMI Provider for additional details.

    For SQL 2008 or 2008 R2
    \\ServerName>\root\Microsoft\SqlServer\ReportServer\RS_<SQLInstanceName>\v10

    For SQL 2012
    \\ServerName>\root\Microsoft\SqlServer\ReportServer\RS_<SQLInstanceName>\v11

    For SQL 2014
    \\ServerName>\root\Microsoft\SqlServer\ReportServer\RS_<SQLInstanceName>\v12

    User-added image

  6. Click Connect
  7. Once you have connected to the WMI instance, click Query…

    User-added image

  8. Enter the following query and click apply:
    select * from msreportserver_instance

    You should see something similar to the following:

    User-added image

If you are unable to connect to WMI, you may need to refer to the article on Troubleshooting WMI Issues. It is also possible you may need to modify WMI permissions.


Additional Information

Install Reporting Services Native Mode Report Server

Was this article helpful ?