SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Configure SSRS with an SSL Certificate


Configure SSRS with an SSL Certificate

Author
Message
Thomas Liddle
Thomas Liddle
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1076 Visits: 115
Comments posted to this topic are about the item Configure SSRS with an SSL Certificate

Thomas Liddle
SQL Server Administrator
Video Blog - YouTube
Web Blog - www.thomasliddledba.com
Twitter - @thomasliddledba
Facebook - @thomasliddledba
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)SSC Guru (233K reputation)

Group: General Forum Members
Points: 233658 Visits: 13373
Hi Thomas,

thanks for the article, very informative.
One question though: is it necessary to create a new SSRS database?
Is there a possibility to reuse the existing one?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
ijafri
ijafri
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 70
hi,

thanks for writing up this article. I have had issues configuring SSRS using SSL. This document will help myself and others.

Can you please continue to add more details to the document. This will be very helpful.
Requesting the following additional information
- Add SSL to a preconfigured ssrs configuration running on port 80.
- Add some trouble shooting steps in case there are some problems.

It's a good startup article with more information added it will become a better documents.

thanks,
ij.
ijafri
ijafri
SSC-Enthusiastic
SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)SSC-Enthusiastic (104 reputation)

Group: General Forum Members
Points: 104 Visits: 70
hi,

thanks for writing up this article. I have had issues configuring SSRS using SSL. This document will help myself and others.

Can you please continue to add more details to the document. This will be very helpful.
Requesting the following additional information
- Add SSL to a preconfigured ssrs configuration running on port 80.
- Add some trouble shooting steps in case there are some problems.
- Please also show the configuration using the Advanced Option
It's a good startup article with more information added it will become a better documents.

thanks,
ij.
ScubaGuy
ScubaGuy
Valued Member
Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)Valued Member (59 reputation)

Group: General Forum Members
Points: 59 Visits: 146
One of the issues we have run into is in requiring SSRS to use SSL otherwise it's just a nice internal site and Mobile Reports are only visible from our network wifi or VPN as we are not in the mood to pass AD credentials in the clear.

Attempts to change "SecureConnectionLevel" and <UrlRoot> work great for reports with SSRS reports however data sets used by mobile are unable to be reached by the mobile reports. Almost seems like Mobile is not able to communicate to the datasets using SSL.

Setting SecureConnectionLevel = 0 seems to be the only method for these to work.
srawant
srawant
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1651 Visits: 532
Hello Thomas,

A self signed Certificate might work and the report url can be hit only within the server itself. Outside of it, you will get error saying that the certificate is not from the trusted authority. How do you resolve it?
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