enable ssl on sql server reporting services

  • Using SQL Server 2008.

    I want to enable ssl on SSRS.

    I created a self signed certificate (tempCA.cer) using makecert utility, then created another certificate (myserver.mycompany.org) signed by tempCA. I installed the certificate in personal and trusted root certification authorities.

    Then I used Reporting Server Configuration tool to enable ssl. On the Web Service URL tab I selected my certificate myserver.mycompany.org for port 443 and on the advanced tab under Multiple SSL identities I added myserver.mycompany.org on port 443 for All IPv4 and All IPv6 and then clicked ok and the Apply.

    It shows two URLs under Report Server Web service URLs

    http://myserver/ReportServer

    https://myServer.mycompany.org/ReportServer

    Under Report Manager URL tab -> Advanced->Multiple SSL Identities for Report Manager, I added myserver.mycompany.org for All IPv4 and All Ipv6. It shows the following urls for Report Manager:

    http:/MyServer/Reports

    and https://MyServer.mycompany.org:443/Reports

    When I go to http:/MyServer/Reports/Pages/Folder.aspx I see the Report manager, but when I go to https://MyServer.mycompany.org:443/Reports/Pages/Folder.aspx I get error "Internet Explorer cannot display the webpage, because the DNS lookup failed. DNS is the network service that translates a website's name to its Internet address. This error is most often caused by having no connection to the Internet or a misconfigured network."

    What am i missing?

  • I created another certificate with CN="Myserver" instead of "CN=myServer.MyOrg.org" and did the configuration the same way as above. It works now.:w00t:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply