Microsoft Knowledge Base Email Alertz

The Microsoft Operations Manager Prerequisite Checker generates an Unable to contact the Microsoft SQL Server Reporting Services server via Web Service error message for Microsoft Operations Manager 2005 Reporting

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 899720 - Last Review: January 30, 2007 - Revision: 2.2

The Microsoft Operations Manager Prerequisite Checker generates an "Unable to contact the Microsoft SQL Server Reporting Services server via Web Service" error message for Microsoft Operations Manager 2005 Reporting

On This Page

SYMPTOMS

Consider the following scenario:
  • You select the option to use Secure Sockets Layer (SSL) when you install Microsoft SQL Server 2000 Reporting Services.
  • You assign a certificate to the SQL Reporting Services Web site that lists the server's fully qualified domain name (FQDN) instead of the server's NetBIOS name.
  • You try to install Microsoft Operations Manager (MOM) 2005 Reporting.
In this scenario, the Prerequisite Checker for MOM 2005 Reporting fails and generates the following message:
Minimum Requirement: Microsoft SQL Server Reporting Services
Required For: MOM Reporting
Detected Value: Unable to contact the Microsoft SQL Server Reporting Services server via Web Service.
Resolution: Please refer to the MOM 2005 installation guide for more information.
Additionally, if you try to open the SQL Reporting Services site by using Microsoft Internet Explorer, you receive the following error message:
The underlying connection was closed: Could not establish trust relationship with remote server.

CAUSE

This occurs because the SQL Reporting Services Web configuration file uses the server's NetBIOS name in the ReportServerURL parameter. This is true even if the certificate on the Web site uses the server's FQDN. If the certificate on the Web site uses the server's FQDN, you cannot open the Web site, and the Prerequisite Checker for MOM 2005 Reporting does not detect the site.

WORKAROUND

To work around this problem, use one of the following methods.

Method 1: SSL is not required

  1. Use Notepad to open the following file:
    Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config
  2. Change "<Add Key="SecureConnectionLevel" Value="3"/>" to "<Add Key="SecureConnectionLevelValue="0"/>".

    Value="3" indicates that SSL is configured.
  3. Save the RSReportServer.config file.
  4. Install MOM 2005 Reporting.

Method 2: SSL is required

  1. Click Start, click Run, type inetmgr.exe, and then click OK.
  2. In Internet Information Services (IIS) Manager, expand Server Name, expand Web Sites, right-click the Default Web Site, and then click Properties.
  3. In Default Web Site Properties, click the Directory Security tab.
  4. Under Secure communication, click View certificate.
  5. Click the General tab, and then verify that there are not any errors or warnings.
  6. Click the Certification Path tab, and then verify that there are not any errors or warnings.
  7. Click the General tab, and then note the FQDN in the Issued to field.

    Note You can also find the FQDN in the Subject property on the Details tab.
  8. Close Internet Information Services Manager.
  9. Add the server FQDN to the SQL Reporting Services Web configuration file. To do this, follow these steps:
    1. Open the RSWebApplication.config file on the Microsoft SQL Server 2000 Reporting Services server.

      Note The RSWebApplication.config file is typically located in the following folder on the SQL Server 2000 Reporting Services server:
      Drive:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
    2. Locate the following line in the RSWebApplication.config file:
      <ReportServerURL>http://ComputerName/ReportServer/</ReportServerURL>
    3. Replace this line with the following line:
      <ReportServerURL>http://Server FQDN/ReportServer/</ReportServerURL>
      Important Do not change "http" to "https".
    4. Save the RSWebApplication.config file.
  10. Click Start, click Run, type iisreset, and then click OK.
  11. Verify that you can open the SQL Reporting Services site by connecting to the following URL in Internet Explorer:
    https://FQDN/Reports
  12. Install MOM 2005 Reporting.
  13. After you finish using the MOM Prerequisite Checker, change the line that you modified in step 9c back to the original line that is mentioned in step 9b.
  14. Save the RSWebApplication.config file.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about how to use a SSL connection for SQL Server 2000 Reporting Services, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/aa902687(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa902687(SQL.80).aspx)

APPLIES TO
  • Microsoft Operations Manager (MOM) 2005
Keywords: 
kberrmsg kbtshoot kbprb KB899720
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate