Microsoft SQL Reporting Services reports an error when I trying to view a deployed report. (NETIQKB53544)

  • 7753544
  • 02-Feb-2007
  • 25-May-2011

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Reporting Services (SRS)
Microsoft Internet Information Server (IIS) 6.0

Situation

Reports are deployed with NetIQ Analysis Center to a secured Site (SSL), but cannot be viewed in Microsoft SQL Server Reporting Services (SRS).

Error: 'The Underlying Connection Was Closed. Could Not Establish Trust Relationship with Remote Server.'

Resolution

You must update the Analysis Center Data Source in Microsoft SQL Reporting Services to reflect the changes. These modifications have not been validated in all environments. Such modifications could affect other applications that utilize Microsoft SQL Reporting Services for reporting or report deployment. If you have any additional questions concerning configuration of Microsoft SQL Reporting Services, contact your Microsoft Technical Support Representative.

For information on how to validate that you have proper SSL certificates setup and configured, see the Microsoft Knowledge Base article http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html/sslsetup.asp

To modify Microsoft Reporting Services Configuration Files:

  1. Browse to ..\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager.
  2. Create a back up of the RSWebApplication.config file to have the HTTPS listing instead of HTTP.
  3. In a text editor, open the RSWebApplication.config file and change the HTTP entry to HTTPS.
  4. Save the file.
  5. Browse to ..\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer.
  6. Create a back up of the RSWebApplication.config file.
  7. In a text editor, open the RSWebApplication.config file and change the HTTP entry to HTTPS.
  8. Save the file.

To update the SRS log files with the FQDN listing, follow the steps above and update the files to reflect the FQDN of the server in the URL path. For example, you would update the URL to use the HTTPS with a FQDN (server.domain.extention ) in place of the server name of the URL. 

To manually update the Analysis Center Data Source within the Microsoft SQL Reporting Service configuration: 

  1. In the Microsoft SQL Reporting Services Report Manager, browse through the NetIQ > Analysis Center structure to locate the Data Source.
  2. Click your Analysis Center Data Source and then select Properties.
  3. In the Connection String entry, update the string to have https and the FQDN for your Report Server. Do not delete any characters.
  4. Scroll to the bottom and click Apply.
  5. Redeploy your report from Analysis Center.

If your issues is not resolved, see the Microsoft Knowledge Base article: http://support.microsoft.com/kb/896861/en-us.

Cause

The Microsoft SSL certificates setup for the Microsoft Internet Information Server are invalid or corrupt.

Additional Information

Formerly known as NETIQKB53544