Microsoft KB Archive/899720

Knowledge Base

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

Article ID: 899720

Article Last Modified on 1/30/2007

---

APPLIES TO

• Microsoft Operations Manager (MOM) 2005

---

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

Keywords: kberrmsg kbtshoot kbprb KB899720

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.