Hi,
ERROR: The underlying connection was closed: Could not establish trust
relationship with remote server.
Iâ'm not able to start the Report Manager (https://myserver/reports) Webapp
using SSL. The WebApp https://myserver/reportserver is working fine.
My current related RSWebApplication.config is
<ReportServerUrl>https://myserver/reportserver.com/reportserver</ReportServerUrl>
My current related RSReportServer.config are:
<Add Key="SecureConnectionLevel" Value="3"/>
<UrlRoot>https:// myserver/reportserver.com/reportserver</UrlRoot>
My Environment:
- SSL Certificate issued to the myserver.com
- Win2003 Server with SQL Server 2000 Enterprise SP3
- Reporting Server SP1
- all related Services are running with a Domain-User Account with local
Admin rights (for the moment)
If I disable SSL (on IIS and within Conf-Files). I am able to start the
Report Manger.
Please helpâ?¦..my server should go live at the end of this weekâ?¦..:-(((
Many thanks
Dominic
Here is the Error Part from the ReportServerWebApp_xxxxx Log:
w3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: The underlying connection was
closed: Could not establish trust relationship with remote server.
w3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Could not
establish trust relationship with remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1454!9/1/2004-11:27:01:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Sorry...here the right config file parts...I did some mixture while replacing
my real values...
My current related RSWebApplication.config is:
<ReportServerUrl>https://myserver.com/reportserver</ReportServerUrl>
My current related RSReportServer.config are:
<Add Key="SecureConnectionLevel" Value="3"/>
<UrlRoot>https://myserver.com/reportserver</UrlRoot>
and - of course - the path I'm using within Internet Explorer is
https://myserver.com/reports|||Hi,
can you check you logfiles for web app and report server and see what errors
do you receive?
Andrej
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:8284C729-96D9-4147-8E01-9EF55B3031CC@.microsoft.com...
> Sorry...here the right config file parts...I did some mixture while
replacing
> my real values...
> My current related RSWebApplication.config is:
> <ReportServerUrl>https://myserver.com/reportserver</ReportServerUrl>
> My current related RSReportServer.config are:
> <Add Key="SecureConnectionLevel" Value="3"/>
> <UrlRoot>https://myserver.com/reportserver</UrlRoot>
> and - of course - the path I'm using within Internet Explorer is
> https://myserver.com/reports|||Hi,
Hmmm...I checked also the Windows Application Event Manager. If I browse to
http://myserver.com/reports Iâ'm getting crypt23 error messages. If I browse
to http://myserver.com/reportservrer - everything is fine. But both are using
the same SSL Certificate. Below the error message:
Failed auto update retrieval of third-party root list sequence number from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt>
with error: The specified server cannot perform the requested operation.
There is no error within In the logfile ReportServerService__xxxxxx.log.
Here is the the errorpart from the ReportServerWebApp__xxxxxx.log:
3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: The underlying connection was
closed: Could not establish trust relationship with remote server.
w3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The underlying connection was closed: Could not
establish trust relationship with remote server.
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1454!9/1/2004-11:27:01:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
Best Regards,
Dominic
"Andrej Hudoklin" wrote:
> Hi,
> can you check you logfiles for web app and report server and see what errors
> do you receive?
>
> Andrej
>
> "Dominic" <Dominic@.discussions.microsoft.com> wrote in message
> news:8284C729-96D9-4147-8E01-9EF55B3031CC@.microsoft.com...
> > Sorry...here the right config file parts...I did some mixture while
> replacing
> > my real values...
> >
> > My current related RSWebApplication.config is:
> > <ReportServerUrl>https://myserver.com/reportserver</ReportServerUrl>
> > My current related RSReportServer.config are:
> > <Add Key="SecureConnectionLevel" Value="3"/>
> > <UrlRoot>https://myserver.com/reportserver</UrlRoot>
> >
> > and - of course - the path I'm using within Internet Explorer is
> > https://myserver.com/reports
>
>|||Well I have the same error with a customer of mine.
Have tried everything and I do not have any idea what else to try.
I'll try to reinstall RS and then see if it will be better.
Please notify me if you'll find a solution.
Regards,
Andrej
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:51189156-E423-419C-BFF9-3B308DED72FF@.microsoft.com...
> Hi,
> Hmmm...I checked also the Windows Application Event Manager. If I browse
to
> http://myserver.com/reports I'm getting crypt23 error messages. If I
browse
> to http://myserver.com/reportservrer - everything is fine. But both are
using
> the same SSL Certificate. Below the error message:
> Failed auto update retrieval of third-party root list sequence number
from:
>
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/
en/authrootseq.txt>
> with error: The specified server cannot perform the requested operation.
> There is no error within In the logfile ReportServerService__xxxxxx.log.
> Here is the the errorpart from the ReportServerWebApp__xxxxxx.log:
> 3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: The underlying connection was
> closed: Could not establish trust relationship with remote server.
> w3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Could not
> establish trust relationship with remote server.
> at System.Net.HttpWebRequest.CheckFinalStatus()
> at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
asyncResult)
> at System.Net.HttpWebRequest.GetRequestStream()
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!1454!9/1/2004-11:27:01:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>
> Best Regards,
> Dominic
>
> "Andrej Hudoklin" wrote:
> > Hi,
> >
> > can you check you logfiles for web app and report server and see what
errors
> > do you receive?
> >
> >
> > Andrej
> >
> >
> >
> > "Dominic" <Dominic@.discussions.microsoft.com> wrote in message
> > news:8284C729-96D9-4147-8E01-9EF55B3031CC@.microsoft.com...
> > > Sorry...here the right config file parts...I did some mixture while
> > replacing
> > > my real values...
> > >
> > > My current related RSWebApplication.config is:
> > > <ReportServerUrl>https://myserver.com/reportserver</ReportServerUrl>
> > > My current related RSReportServer.config are:
> > > <Add Key="SecureConnectionLevel" Value="3"/>
> > > <UrlRoot>https://myserver.com/reportserver</UrlRoot>
> > >
> > > and - of course - the path I'm using within Internet Explorer is
> > > https://myserver.com/reports
> >
> >
> >|||Hi Andrej
...did you found a solution? Did a reinstall resolve your problem? Iâ've
still no solution..:-(
Regards,
Dominic
"Andrej Hudoklin" wrote:
> Well I have the same error with a customer of mine.
> Have tried everything and I do not have any idea what else to try.
> I'll try to reinstall RS and then see if it will be better.
> Please notify me if you'll find a solution.
>
> Regards,
> Andrej
>
> "Dominic" <Dominic@.discussions.microsoft.com> wrote in message
> news:51189156-E423-419C-BFF9-3B308DED72FF@.microsoft.com...
> > Hi,
> >
> > Hmmm...I checked also the Windows Application Event Manager. If I browse
> to
> > http://myserver.com/reports I'm getting crypt23 error messages. If I
> browse
> > to http://myserver.com/reportservrer - everything is fine. But both are
> using
> > the same SSL Certificate. Below the error message:
> > Failed auto update retrieval of third-party root list sequence number
> from:
> >
> <http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/
> en/authrootseq.txt>
> > with error: The specified server cannot perform the requested operation.
> >
> > There is no error within In the logfile ReportServerService__xxxxxx.log.
> >
> > Here is the the errorpart from the ReportServerWebApp__xxxxxx.log:
> > 3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: The underlying connection was
> > closed: Could not establish trust relationship with remote server.
> > w3wp!ui!1454!9/1/2004-11:26:59:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The underlying connection was closed: Could not
> > establish trust relationship with remote server.
> > at System.Net.HttpWebRequest.CheckFinalStatus()
> > at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
> asyncResult)
> > at System.Net.HttpWebRequest.GetRequestStream()
> > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > at
> Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > at
> Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > at
> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname)
> > at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level)
> > at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args)
> > at System.EventHandler.Invoke(Object sender, EventArgs e)
> > at System.Web.UI.Control.OnInit(EventArgs e)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!1454!9/1/2004-11:27:01:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> >
> >
> > Best Regards,
> > Dominic
> >
> >
> > "Andrej Hudoklin" wrote:
> >
> > > Hi,
> > >
> > > can you check you logfiles for web app and report server and see what
> errors
> > > do you receive?
> > >
> > >
> > > Andrej
> > >
> > >
> > >
> > > "Dominic" <Dominic@.discussions.microsoft.com> wrote in message
> > > news:8284C729-96D9-4147-8E01-9EF55B3031CC@.microsoft.com...
> > > > Sorry...here the right config file parts...I did some mixture while
> > > replacing
> > > > my real values...
> > > >
> > > > My current related RSWebApplication.config is:
> > > > <ReportServerUrl>https://myserver.com/reportserver</ReportServerUrl>
> > > > My current related RSReportServer.config are:
> > > > <Add Key="SecureConnectionLevel" Value="3"/>
> > > > <UrlRoot>https://myserver.com/reportserver</UrlRoot>
> > > >
> > > > and - of course - the path I'm using within Internet Explorer is
> > > > https://myserver.com/reports
> > >
> > >
> > >
>
>
Saturday, February 25, 2012
Could not establish trust relationship with remote server
Labels:
closed,
connection,
database,
error,
establish,
iacirc,
microsoft,
mysql,
oracle,
relationship,
remote,
server,
sql,
trust,
underlying
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment