Another SSL-Related problem?

I have seen all the other SSL related problems, and I don't think I am
having the same issue...but I am having something similar.
I have Reporting Services SP1 installed on the same machine as SQL
Server. IIS is also on this machine. The machine is not part of a
domain and its full name is SQL2. I have an internal CA within my
domain that I used to issue a certificate to SQL2 under the name SQL2.
I have set up my reports to deply to https://SQL2/ReportServer
Reports deploy fine and with no error. I can view the report by going
to https://SQL2/ReportManager or http://SQL2/ReportManager and it takes
parameters and returns data, exactly as it does in debug mode in
vs.net.
What doesn't work:
If I go to the report properties tab (SSL or not) within the report I
get the following error:
The underlying connection was closed: Could not establish trust
relationship with remote server.
If I try to go to the data source instead of the report (SSL or not),
I get the following error:
The underlying connection was closed: Could not establish trust
relationship with remote server.
If I try to export the report to another format for download (SSL or
not), I get a file not found error.
When I search for the "The underlying connection was closed: Could not
establish trust relationship with remote server." error message, it
seems like everyone who gets that cannot deploy the report or view it.
I can deploy and view with no problems, but it seems like I can't do
anything else.
Any ideas?
Thanks in advance.
ErikI'm experiencing the exact same problems. I'm also receiving the error
when saving a new report subscription. Any help would be greatly
appreciated.
Thanks
Chad
cybermud wrote:
> I have seen all the other SSL related problems, and I don't think I am
> having the same issue...but I am having something similar.
> I have Reporting Services SP1 installed on the same machine as SQL
> Server. IIS is also on this machine. The machine is not part of a
> domain and its full name is SQL2. I have an internal CA within my
> domain that I used to issue a certificate to SQL2 under the name SQL2.
> I have set up my reports to deply to https://SQL2/ReportServer
> Reports deploy fine and with no error. I can view the report by going
> to https://SQL2/ReportManager or http://SQL2/ReportManager and it takes
> parameters and returns data, exactly as it does in debug mode in
> vs.net.
> What doesn't work:
> If I go to the report properties tab (SSL or not) within the report I
> get the following error:
> The underlying connection was closed: Could not establish trust
> relationship with remote server.
> If I try to go to the data source instead of the report (SSL or not),
> I get the following error:
> The underlying connection was closed: Could not establish trust
> relationship with remote server.
> If I try to export the report to another format for download (SSL or
> not), I get a file not found error.
> When I search for the "The underlying connection was closed: Could not
> establish trust relationship with remote server." error message, it
> seems like everyone who gets that cannot deploy the report or view it.
> I can deploy and view with no problems, but it seems like I can't do
> anything else.
> Any ideas?
> Thanks in advance.
> Erik
>|||I tried giving the site a proper DNS name, sql2.domain.com, and
generated a new SSL certificate for that name, and I am still having
all the same issues. Reports work fine, but I cannot view a data
source or go to the report properties. I still get the same "The
underlying connection was closed: Could not establish trust
relationship with remote server." error message. Additionally, like
Chad, I cannot save a subscription. I get the same "The underlying
connection was closed: Could not establish trust relationship with
remote server." error message. Has anyone else had a similar
situation?
Thanks,
Erik|||Chad:
I edited the RSReportServer.config file to tell Reporting Services not
to use SSL at all, then restarted the web site, and now I can view the
properties, view the data source, and export files. If you want to try
this, open the file in notepad, look for the following string:
<Add Key="SecureConnectionLevel" Value="0"/>
make sure value is 0. that means no SSL. I found this in the sample
chaper for Hitchhikers Guide To Reporting Services. Its somewhere out
there on the internet.
Erik|||Hi Erik,
I receive the error both on by development machine and the production
server. The production website has a fully qualified domain name with a
valid SSL certificate. My development machine has a test certificate I
created with Makecert.exe. Both of the machines have the exact same
symptoms.
I have changed the Security Level within the RSReportServer.config on my
development machine. With the option set to 0, everything seems to
work. If the Security Level is set to 1, I start receiving the
underlying connection error. I also received the security warning when
rendering reports. If the level is set to 2, the just receive the
underlying connection error. If the level is set to 3, the site stops
working all together. I wish could just set the level to 0, but I can't
on the production site.
I did some research on the error itself. It seems to be a general
problem with the SOAP protocol and SSL. Since Web Services use SOAP and
SQL Reporting uses Web Services, I'm wonder if thats the primary cause
for the underlying connection error.
Thanks
Chad
cybermud wrote:
> Chad:
> I edited the RSReportServer.config file to tell Reporting Services not
> to use SSL at all, then restarted the web site, and now I can view the
> properties, view the data source, and export files. If you want to try
> this, open the file in notepad, look for the following string:
> <Add Key="SecureConnectionLevel" Value="0"/>
> make sure value is 0. that means no SSL. I found this in the sample
> chaper for Hitchhikers Guide To Reporting Services. Its somewhere out
> there on the internet.
> Erik
>|||Chad:
No SSL will be a no-go for me as well, but its nice to see some of the
other options. I wonder if the problem has to do with my SQL Server
not being a member of the domain that the certificate authority that
issued its certificate is a member of. Anyone...?
Erik|||This is not a valid solution to this problem.
Setting SecureConnectionLevel = 0 makes the report server NOT REQUIRE SSL.
As such, any links to the report server are made over an unprotected SSL
connection.
Your more likely solution is to edit the Report Manager configuration file
to change the REPORTSERVERURL property to be https://sql2/reportserver.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"cybermud" <cybermud@.gmail.com> wrote in message
news:1107797287.951689.55530@.g14g2000cwa.googlegroups.com...
> Chad:
> I edited the RSReportServer.config file to tell Reporting Services not
> to use SSL at all, then restarted the web site, and now I can view the
> properties, view the data source, and export files. If you want to try
> this, open the file in notepad, look for the following string:
> <Add Key="SecureConnectionLevel" Value="0"/>
> make sure value is 0. that means no SSL. I found this in the sample
> chaper for Hitchhikers Guide To Reporting Services. Its somewhere out
> there on the internet.
> Erik
>|||Lukasz:
Thank you for your reply. I have tried changing this value previosly
and it has had no effect on resolving my issue. I tried it again for
good measure, setting the REPORTSERVERURL to https://sql2/reportserver,
then changed the SECURECONNECTIONLEVEL to 3. Upon restarting IIS, I
cannot even view report manager, as I get an error of "The underlying
connection was closed: Could not establish trust relationship with
remote server."
If I change the SECURECONNECTIONLEVEL to 2, I can connect and view
reports, but I cannot view daa source properties, export reports, view
report properties, or save a new subscription.
Could this problem be because the CA that I used to issue the SSL
certificate is a domain member, and SQL2 is not a domain member? Would
joining SQL2 to my domain solve the issue?
Thanks in advance for any insight you may be able to provide.|||OK, I joined SQL2 to my domain.
Everything now works great with the SECURECONNECTIONLEVEL set to 3,
except I still can't export reports to any other format unless
SECURECONNECTIONLEVEL is set to 0. Any ideas?|||Hmm... so the CA was on the domain, but your SQL2 box was not on the domain?
What URL were you using to connect to the reportserver on this box?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"cybermud" <cybermud@.gmail.com> wrote in message
news:1107893981.484348.53620@.g14g2000cwa.googlegroups.com...
> OK, I joined SQL2 to my domain.
> Everything now works great with the SECURECONNECTIONLEVEL set to 3,
> except I still can't export reports to any other format unless
> SECURECONNECTIONLEVEL is set to 0. Any ideas?
>|||Lukasz:
Yes, CA was in domain, SQL2 was not. Now SQL2 is in the domain.
I was using https://sql2/ReportServer to access the report server. Now
I am using https://sql2.domain.com/ReportServer to access report
server, and https://sql2.domain.com/ReportManager to access the report
manager. And I can only export to a file if the security parameter is
set to 0. Any other setting and it looks as if the file is never
generated...when I click on the export link, it does not show a file
name like it does when the security parameter is set at 0.|||Gang:
I was looking through my log files for Reporting Services, and I
noticed the following entries:
w3wp!library!c70!02/14/2005-12:09:03:: i INFO: Call to RenderNext(
'/Sales Reporting Project/Top 50 Market Report - Month' )
w3wp!chunks!c70!02/14/2005-12:09:03:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=236c9c34-01c8-4806-9d14-4c06b744d28a
w3wp!cache!c70!02/14/2005-12:09:04:: i INFO: Session live: /Sales
Reporting Project/Top 50 Market Report - Month
w3wp!webserver!c70!02/14/2005-12:09:04:: i INFO: Processed report.
Report='/Sales Reporting Project/Top 50 Market Report - Month',
Stream=''
w3wp!library!574!02/14/2005-12:09:20:: i INFO: Call to RenderNext(
'/Sales Reporting Project/Top 50 Market Report - Month' )
w3wp!cache!574!02/14/2005-12:09:20:: i INFO: Session live: /Sales
Reporting Project/Top 50 Market Report - Month
w3wp!webserver!574!02/14/2005-12:09:20:: i INFO: Processed report.
Report='/Sales Reporting Project/Top 50 Market Report - Month',
Stream=''
w3wp!library!c70!02/14/2005-12:09:34:: i INFO: Call to RenderNext(
'/Sales Reporting Project/Top 50 Market Report - Month' )
w3wp!chunks!c70!02/14/2005-12:09:34:: i INFO: ###
GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
this=236c9c34-01c8-4806-9d14-4c06b744d28a
w3wp!cache!c70!02/14/2005-12:09:34:: i INFO: Session live: /Sales
Reporting Project/Top 50 Market Report - Month
w3wp!webserver!c70!02/14/2005-12:09:34:: i INFO: Processed report.
Report='/Sales Reporting Project/Top 50 Market Report - Month',
Stream=''
w3wp!library!1254!02/14/2005-12:09:40:: i INFO: Call to RenderNext(
'/Sales Reporting Project/Top 50 Market Report - Month' )
w3wp!chunks!1254!02/14/2005-12:09:40:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', 2), chunk was not found!
this=236c9c34-01c8-4806-9d14-4c06b744d28a
w3wp!cache!1254!02/14/2005-12:09:40:: i INFO: Session live: /Sales
Reporting Project/Top 50 Market Report - Month
w3wp!webserver!1254!02/14/2005-12:09:40:: i INFO: Processed report.
Report='/Sales Reporting Project/Top 50 Market Report - Month',
Stream=''
It seems as if I get a "Chunk Not Found" error when I try to export to
any format with SSL enabled.
Has anybody else encountered this? Has anyone else encountered a "file
nto found" error when trying to export into any format from Report
Manager?
When I export in vs.net it works fine, and if I turn SSL off on the web
site it will export fine...but not with SSL on.|||Hi Erik,
Sorry the delay in check this thread. I have not been able to solve the
SSL problem. I was able to create subscriptions through SSL using the
SQL Reporting SOAP APIs. It's more work, because you have to code your
own interface, but it does work through SSL.
Thanks
Chad
cybermud wrote:
> Gang:
> I was looking through my log files for Reporting Services, and I
> noticed the following entries:
> w3wp!library!c70!02/14/2005-12:09:03:: i INFO: Call to RenderNext(
> '/Sales Reporting Project/Top 50 Market Report - Month' )
> w3wp!chunks!c70!02/14/2005-12:09:03:: i INFO: ###
> GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
> this=236c9c34-01c8-4806-9d14-4c06b744d28a
> w3wp!cache!c70!02/14/2005-12:09:04:: i INFO: Session live: /Sales
> Reporting Project/Top 50 Market Report - Month
> w3wp!webserver!c70!02/14/2005-12:09:04:: i INFO: Processed report.
> Report='/Sales Reporting Project/Top 50 Market Report - Month',
> Stream=''
> w3wp!library!574!02/14/2005-12:09:20:: i INFO: Call to RenderNext(
> '/Sales Reporting Project/Top 50 Market Report - Month' )
> w3wp!cache!574!02/14/2005-12:09:20:: i INFO: Session live: /Sales
> Reporting Project/Top 50 Market Report - Month
> w3wp!webserver!574!02/14/2005-12:09:20:: i INFO: Processed report.
> Report='/Sales Reporting Project/Top 50 Market Report - Month',
> Stream=''
> w3wp!library!c70!02/14/2005-12:09:34:: i INFO: Call to RenderNext(
> '/Sales Reporting Project/Top 50 Market Report - Month' )
> w3wp!chunks!c70!02/14/2005-12:09:34:: i INFO: ###
> GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> this=236c9c34-01c8-4806-9d14-4c06b744d28a
> w3wp!cache!c70!02/14/2005-12:09:34:: i INFO: Session live: /Sales
> Reporting Project/Top 50 Market Report - Month
> w3wp!webserver!c70!02/14/2005-12:09:34:: i INFO: Processed report.
> Report='/Sales Reporting Project/Top 50 Market Report - Month',
> Stream=''
> w3wp!library!1254!02/14/2005-12:09:40:: i INFO: Call to RenderNext(
> '/Sales Reporting Project/Top 50 Market Report - Month' )
> w3wp!chunks!1254!02/14/2005-12:09:40:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', 2), chunk was not found!
> this=236c9c34-01c8-4806-9d14-4c06b744d28a
> w3wp!cache!1254!02/14/2005-12:09:40:: i INFO: Session live: /Sales
> Reporting Project/Top 50 Market Report - Month
> w3wp!webserver!1254!02/14/2005-12:09:40:: i INFO: Processed report.
> Report='/Sales Reporting Project/Top 50 Market Report - Month',
> Stream=''
> It seems as if I get a "Chunk Not Found" error when I try to export to
> any format with SSL enabled.
> Has anybody else encountered this? Has anyone else encountered a "file
> nto found" error when trying to export into any format from Report
> Manager?
> When I export in vs.net it works fine, and if I turn SSL off on the web
> site it will export fine...but not with SSL on.
>