Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSL Certificates on SQL Server 2005 for Reporting Services


SSL Certificates on SQL Server 2005 for Reporting Services

Author
Message
debrucer1
debrucer1
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 136
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/drussell/sslcertificatesonsqlserver2005forreportingservices.asp

Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
Andy Hogg
Andy Hogg
Mr or Mrs. 500
Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)

Group: General Forum Members
Points: 596 Visits: 1012

What a great article, following it through I was able to get SSL working on my RS 2005 installation first time!

Shame on Microsoft for making it so arcane and obscure to do this. I couldn't find any documentation at microsoft.com that explained these file changes - would it really have been so hard to knock up a Wizard to do all this for you?


Dale Voss
Dale Voss
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

This is excellent information - which solves many SQL Server / Reporting Services install and usage issues - thank you very much!!!

I also agree that Microsoft has some work to do - It's a bad install - plain and simple.


Jerry Rice-346371
Jerry Rice-346371
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 16
I know this is way late after the fact, but here is the way to enable http just for the RS Help pages, which allows the non-SSL help page link to work...

From Roman Rehak: [url=http://www.sqljunkies.com/WebLog/roman/archive/category/370.aspx][/url]

"- Expand the Reports site in IIS Manager, open the properties of the EN subfolder and uncheck the SSL setting. The EN folder contains the English help files so deselecting SSL on that folder will allow you to view help without SSL. You will need to modify other folders if you use help other than English."
witold.lulka
witold.lulka
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 237
Hi,

How can configure SQL 2008 RS for SSL connection? I have actually this error:
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

Witold Lulka
Rohit
Rohit
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 12
i need help to understand how ssl is working, as currently i have web server, my customer uses https connection to web site, while my database and reporting server in the another vlan where customer do not have access. since i have vpn access, i am able to access the report, but my coming from the same website cannot access the report. Any idea what should i do, i am new at this SSL for the reporting service.


RJPATEL

Mani-584606
Mani-584606
Right there with Babe
Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)Right there with Babe (720 reputation)

Group: General Forum Members
Points: 720 Visits: 1998
Is SQL Server 2008 Reporting Services Configuration Manager won't create Virtual directories in IIS? like ReportServer & Reports under default website in IIS?

Thanks
Lucien Monamay
Lucien Monamay
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 122
Do you mean that once SSL is activated the only way to access the ReportServer will be over https not anymore http?
crprasad
crprasad
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1
Hi,
I have followed the instructions exactly as in the article but at the end still I am getting the same error
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
Environment is SQL Server 2005 Reporting services
crprasad
crprasad
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1
It resolved. One additional thing that I did which worked for me is. Installed the certificate in "Trusted Root Authority" store on the server.

.. On the server
1. Accessed the server repors URL
2.Clicked on the Certificate Error message on the browser.
3.Clicked "Install Cetificate"
4.Choosen "Trusted Root Certification Authorities" store to install the certificate.

Now my reporting services are working fine on SSL.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search