Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

enable ssl on sql server reporting services Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 8:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 6, 2013 4:33 PM
Points: 8, Visits: 35
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?
Post #1486089
Posted Tuesday, August 20, 2013 5:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 6, 2013 4:33 PM
Points: 8, Visits: 35
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.
Post #1486198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse