Thursday, March 29, 2012

export fails using https

Hi
Running the unpatched Reporting Services (ie no service pack) I find
everything is working great other than exporting.
After playing around with things I find that if I use http then the
exports work fine, but if I reconfigure for https, they don't.
So,
http://myRSserver/Reports/Pages/Report.aspx?ItemPath=%2fGeneral%2fTestList
is generated perfectly, and exporting as PDF works too.
Once I change things to work with https,
https://myRSserver/Reports/Pages/Report.aspx?ItemPath=%2fGeneral%2fTestList
is still fine, but I can no longer export. Instead I get the
depressingly familiar
"Internet explorer cannot download format = PDF from myRSserver"
message.
Has anyone else encountered and overcomt this?
Thanks
StewartIs your report server (web service, etc.) configured for HTTPS too in the RS
config files? I'm wondering if that makes a difference...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"sdm" <macneisd-www@.dcs.gla.ac.uk> wrote in message
news:1108396598.676768.161140@.l41g2000cwc.googlegroups.com...
> Hi
> Running the unpatched Reporting Services (ie no service pack) I find
> everything is working great other than exporting.
> After playing around with things I find that if I use http then the
> exports work fine, but if I reconfigure for https, they don't.
> So,
> http://myRSserver/Reports/Pages/Report.aspx?ItemPath=%2fGeneral%2fTestList
> is generated perfectly, and exporting as PDF works too.
> Once I change things to work with https,
> https://myRSserver/Reports/Pages/Report.aspx?ItemPath=%2fGeneral%2fTestList
> is still fine, but I can no longer export. Instead I get the
> depressingly familiar
> "Internet explorer cannot download format = PDF from myRSserver"
> message.
> Has anyone else encountered and overcomt this?
> Thanks
> Stewart
>|||I encounter that message when using HTTPS as well. The dreaded
"Internet explorer cannot download format = PDF from myRSserver"
message."
I have tried changing the config files, changing the URL, re-issuing
the certificate, re-issueing to a new URL, etc, etc to no avail. It
works great when not using SSL, but I would like to eventually make
this server publicly available, so SSL is a requirement.
Erik|||Have you tried a fresh install of RS? There is a step where it prompts you
to select SSL or not. That is probably overkill, but if others haven't seen
your error, then it might be your shortest route to success.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"cybermud" <cybermud@.gmail.com> wrote in message
news:1108499154.037629.202680@.o13g2000cwo.googlegroups.com...
>I encounter that message when using HTTPS as well. The dreaded
> "Internet explorer cannot download format = PDF from myRSserver"
> message."
> I have tried changing the config files, changing the URL, re-issuing
> the certificate, re-issueing to a new URL, etc, etc to no avail. It
> works great when not using SSL, but I would like to eventually make
> this server publicly available, so SSL is a requirement.
> Erik
>|||Jeff:
Thanks for the reply. According to "Hitchhikers Guide To Reporting
Services" you can change this setting after the install by editing the
RSReportServer.config file, which I have done and it does affect the
usage of SSL. But perhaps there is some setting that is set in the
install and canot be changed by modifying that file. I am pretty sure
that I did have the SSL box checked at install, though, because I
remember creating the SSL certificate for the machine prior to
installing, but I could be mistaken. If I can't figure it out, I will
probably re-install next week. Thanks for the advice.
Erik|||Thanks for the replies, apologies for being offline the past 2 days.
I think Erik's replies mirror my own experiences. I tried with https
selected at setup, then again with no https selected at setup.
Everything worked on the second go until I manually changed things to
use https, as Erik described. I've tried reinstalling.
The only thought I have as I write this is that my certificate is
simply for 'myRSserver' rather than the fully qualified domain name.
I'll perhaps get a different certificate and try on a fresh install.
I'll post again if I have any success.
Stewart|||Stewart:
At one point I was using a certificate named only for the computer
name, and tought that may be the issue. So I joined the computer to my
domain, and issued a certificate for the fully qualified domain name,
but that did not solve anything. I am still having the same problems
with export.
Erik|||Ah, okay, thanks for that.
I've been looking (unsuccessfully) for some place that defines the URL
used by the export call - I don't know if the error is caused by an
incorrect URL or authentication failure, or something completely
different.
Thanks anyway.
Stewart|||Stewart:
I was looking at the URL, and broke it down, and compared when its set
up to use SSL and when its set up not to use SSL. The only difference
is HTTPS vs HTTP...I have not been able to find anything in the
configuration relating to export location, though.
Erik|||Hi,
I had a similar problem.Basically it is a browser problem.I came to know
about it when I tried it over Netscape and it worked. It also worked with
win-xp.This made me think about a security setting in the browser.
It was solved when I unchecked the checkbox for "Do not save encrypted
pages to disk" which resides in tools -> internet options-> Advanced ->
Security section of the browser.
Regards.|||Thanks for that, I'll give it a go on a test server!
Stewart|||SQLReporter, you are my hero!! This solved my problem!

No comments:

Post a Comment