Unable to access Report Manager

• mikemartineac

  SSC Veteran

  Points: 275

  More actions

  July 6, 2011 at 8:02 am

  #240871

  Hi,

  I am unable to access Report Manager in Reporting Services 2008.

  My target server URL is http://<servername>/ReportServer.

  Accessing report manager by entering "http://<servername>/Reports" into the I.E. address bar results in the following error:

  "There is a problem with this website's security certificate."

  Deploying a report in MS Visual Studio 2008 results in the following error:

  "Could not connect to the report server 'http://<servername>/ReportServer'. Verify that the Target Server URL is valid and that you have the correct permissions to connect to the report server. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)"

  Please advise me on this.

  Thanks

  Mike M.

• eccentricDBA

  SSCarpal Tunnel

  Points: 4844

  More actions

  July 6, 2011 at 8:12 am

  #1348998

  It sounds like you have an expired/invalid SSL certificate. However, your stating your using http.

  If you go to Start - Programs - Microsoft SQL Server 2008 - Configuration Tools - Reporting Services Configuration Manager

  What are you showing for the Web Service URL and Report Manager URL? Do you have SSL Certificate Defined there?

  In Report Manager URL you will need to click the Advanced button to check.

• mikemartineac

  SSC Veteran

  Points: 275

  More actions

  July 6, 2011 at 11:10 am

  #1349153

  Hi,

  Thanks for your response.

  There are two SSL Certificates (same name listed)

  IP Address:

  All IPv4

  All IPv6

  SSL Port:

  443

  443

  IP Address:

  All Assigned

  TCP Port:

  80

  Web URLs:

  http://<servername&gt;:80/ReportServer

  https://<SSL certificate name>:443/ReportServer

  Report Manger URLs:

  http://<servername&gt;:80/Reports

  https://<SSL certificate name>:443/Reports

  Mike