Friday, March 9, 2012

Problem Deploying Reports when using SSL

Here is my current setup. I have Report Services sp1 installed on a Windows
2000 machine with SQL Server 2000. We have successfully configured RS to
produce reports over the internet via SSL. The actual viewing of the report
over the internet works great. However, in Visual Studio I receive the
following error when trying to deploy the reports...
"The underlying connection was closed. Could not establish trust
relationship with remote server"
The only work around I have found so far is to modify the
rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
Then I am able to deploy the reports and do not receive this message.
Because SSL is a must, I then have to change the secureconnectionlevel= back
to 2.
Users externally are accessing the report server via
http://FQDN/reportserver. I had gone into the rswebapplication.config file
and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to
<ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My
certificate name uses the FQDN as the site name.
My question is why I am not able to deploy my reports when the SSL is turned
on?
I hope this makes sense and I am sure I left something out. Please let me
know your thoughts. Thanks!Sounds like you're hitting the issue in this KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;823177. Are you
specifying the FQDN in VS when deploying the reports?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:B42B3849-C5FA-45AB-AEDA-D769D49ED57D@.microsoft.com...
> Here is my current setup. I have Report Services sp1 installed on a
> Windows
> 2000 machine with SQL Server 2000. We have successfully configured RS to
> produce reports over the internet via SSL. The actual viewing of the
> report
> over the internet works great. However, in Visual Studio I receive the
> following error when trying to deploy the reports...
> "The underlying connection was closed. Could not establish trust
> relationship with remote server"
> The only work around I have found so far is to modify the
> rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
> Then I am able to deploy the reports and do not receive this message.
> Because SSL is a must, I then have to change the secureconnectionlevel=> back
> to 2.
> Users externally are accessing the report server via
> http://FQDN/reportserver. I had gone into the rswebapplication.config
> file
> and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl>
> to
> <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck.
> My
> certificate name uses the FQDN as the site name.
> My question is why I am not able to deploy my reports when the SSL is
> turned
> on?
> I hope this makes sense and I am sure I left something out. Please let me
> know your thoughts. Thanks!
>

No comments:

Post a Comment