Saturday, February 25, 2012

Could not establish trust relationship with remote server.

Error comes up when I try to deploy RS to my web server, "The underlying
connection was closed: Could not establish trust relationship with remote
server." Web server has valid certificate, and I'm using https in my
connection.
OverwriteDataSources: True
TargetFolder: Reports
TargetServerURL: https://webserver/ReportServer
I'm able to see https://webserver/ReportServer through IE, and I see the
folder Reports. I clicked on Reports and I see my old RS files.I also tried without the s in https, but I still get the same error message.
http://webserver/ReportServer
"Mike L" wrote:
> Error comes up when I try to deploy RS to my web server, "The underlying
> connection was closed: Could not establish trust relationship with remote
> server." Web server has valid certificate, and I'm using https in my
> connection.
> OverwriteDataSources: True
> TargetFolder: Reports
> TargetServerURL: https://webserver/ReportServer
> I'm able to see https://webserver/ReportServer through IE, and I see the
> folder Reports. I clicked on Reports and I see my old RS files.
>|||Hello Cadel,
You may try the following steps to disable SSL on report server to test:
1. Within the RSReportServer.config file you'll find in "\Program
Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer",
set secureconnectionlevel to 0.
Change
<UrlRoot>https://webserver/ReportServer</UrlRoot>
<UrlRoot>http://webserver/ReportServer</UrlRoot>
2. within C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager, change
<ReportServerUrl>https://webserver/ReportServer</ReportServerUrl> to
<ReportServerUrl>http://webserver/ReportServer</ReportServerUrl>
Note: Please backup above files to safe place before you try to modify
them. You may need to restart IIS if it is not take effect
After that, you may want to configure deploy server to
http://webserver/ReportServer in VS to test the situatioin.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Could not establish trust relationship with remote server.
>thread-index: AcYgX/vgGz1j0C1/RduYsSVDkkJvAQ==>X-WBNR-Posting-Host: 204.87.106.66
>From: =?Utf-8?B?TWlrZSBM?= <Cadel@.nospam.nospam>
>References: <18E8F20D-2CC6-4F76-9687-BE23EE3D3687@.microsoft.com>
>Subject: RE: Could not establish trust relationship with remote server.
>Date: Mon, 23 Jan 2006 13:00:04 -0800
>Lines: 18
>Message-ID: <A3C8E145-FFF3-4828-BC7F-C0C443BFCF63@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67357
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>I also tried without the s in https, but I still get the same error
message.
>http://webserver/ReportServer
>"Mike L" wrote:
>> Error comes up when I try to deploy RS to my web server, "The underlying
>> connection was closed: Could not establish trust relationship with
remote
>> server." Web server has valid certificate, and I'm using https in my
>> connection.
>> OverwriteDataSources: True
>> TargetFolder: Reports
>> TargetServerURL: https://webserver/ReportServer
>> I'm able to see https://webserver/ReportServer through IE, and I see the
>> folder Reports. I clicked on Reports and I see my old RS files.
>|||1. I set "secureconnectionlevel" to zero, the URLRoot was already
"<UrlRoot>http://WEBSERVER/ReportServer</UrlRoot>", so I didn't change that.
2. RSReportServer.config in ReportManager, already had
"<ReportServerUrl>http://WEBSERVER/ReportServer</ReportServerUrl>"
When I tried to deploy in VS, I made sure the TargetServerURL was
"http://webserver/ReportServer", and the TargetFolder was "Reports".
I now get the error, "c:\intranet\Claims.rds The permissions granted to user
'WEBSERVER\IUSR_WEBSERVER' are insufficient for performing this operation."
"Peter Yang [MSFT]" wrote:
> Hello Cadel,
> You may try the following steps to disable SSL on report server to test:
> 1. Within the RSReportServer.config file you'll find in "\Program
> Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer",
> set secureconnectionlevel to 0.
> Change
> <UrlRoot>https://webserver/ReportServer</UrlRoot>
> <UrlRoot>http://webserver/ReportServer</UrlRoot>
> 2. within C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager, change
> <ReportServerUrl>https://webserver/ReportServer</ReportServerUrl> to
> <ReportServerUrl>http://webserver/ReportServer</ReportServerUrl>
> Note: Please backup above files to safe place before you try to modify
> them. You may need to restart IIS if it is not take effect
> After that, you may want to configure deploy server to
> http://webserver/ReportServer in VS to test the situatioin.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> >Thread-Topic: Could not establish trust relationship with remote server.
> >thread-index: AcYgX/vgGz1j0C1/RduYsSVDkkJvAQ==> >X-WBNR-Posting-Host: 204.87.106.66
> >From: =?Utf-8?B?TWlrZSBM?= <Cadel@.nospam.nospam>
> >References: <18E8F20D-2CC6-4F76-9687-BE23EE3D3687@.microsoft.com>
> >Subject: RE: Could not establish trust relationship with remote server.
> >Date: Mon, 23 Jan 2006 13:00:04 -0800
> >Lines: 18
> >Message-ID: <A3C8E145-FFF3-4828-BC7F-C0C443BFCF63@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67357
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >I also tried without the s in https, but I still get the same error
> message.
> >
> >http://webserver/ReportServer
> >
> >"Mike L" wrote:
> >
> >> Error comes up when I try to deploy RS to my web server, "The underlying
> >> connection was closed: Could not establish trust relationship with
> remote
> >> server." Web server has valid certificate, and I'm using https in my
> >> connection.
> >>
> >> OverwriteDataSources: True
> >> TargetFolder: Reports
> >> TargetServerURL: https://webserver/ReportServer
> >>
> >> I'm able to see https://webserver/ReportServer through IE, and I see the
> >> folder Reports. I clicked on Reports and I see my old RS files.
> >>
> >
>|||Hello Cadel,
It seems your report server is configured to allow anonymous
authentication. Please check the following settings:
1. Run Inetmgr, right click Reportserver virtual
directory->Properties->Directory Security tab
2. Click Edit, and uncheck "Enable anonymouse access", make sure
"Integrated Windows authentication" is checked.
3. Restart IIS to test
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Could not establish trust relationship with remote server.
>thread-index: AcYhHcfqfQzv5KrkRySdCQqp8f5RKg==>X-WBNR-Posting-Host: 204.87.106.66
>From: =?Utf-8?B?TWlrZSBM?= <Cadel@.nospam.nospam>
>References: <18E8F20D-2CC6-4F76-9687-BE23EE3D3687@.microsoft.com>
<A3C8E145-FFF3-4828-BC7F-C0C443BFCF63@.microsoft.com>
<Kuu46qKIGHA.1236@.TK2MSFTNGXA02.phx.gbl>
>Subject: RE: Could not establish trust relationship with remote server.
>Date: Tue, 24 Jan 2006 11:38:41 -0800
>Lines: 111
>Message-ID: <38F8AA05-20C3-4BDB-B64F-6629EB127703@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67414
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>1. I set "secureconnectionlevel" to zero, the URLRoot was already
>"<UrlRoot>http://WEBSERVER/ReportServer</UrlRoot>", so I didn't change
that.
>2. RSReportServer.config in ReportManager, already had
>"<ReportServerUrl>http://WEBSERVER/ReportServer</ReportServerUrl>"
>When I tried to deploy in VS, I made sure the TargetServerURL was
>"http://webserver/ReportServer", and the TargetFolder was "Reports".
>I now get the error, "c:\intranet\Claims.rds The permissions granted to
user
>'WEBSERVER\IUSR_WEBSERVER' are insufficient for performing this operation."
>
>
>
>"Peter Yang [MSFT]" wrote:
>> Hello Cadel,
>> You may try the following steps to disable SSL on report server to test:
>> 1. Within the RSReportServer.config file you'll find in "\Program
>> Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer",
>> set secureconnectionlevel to 0.
>> Change
>> <UrlRoot>https://webserver/ReportServer</UrlRoot>
>> <UrlRoot>http://webserver/ReportServer</UrlRoot>
>> 2. within C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager, change
>> <ReportServerUrl>https://webserver/ReportServer</ReportServerUrl> to
>> <ReportServerUrl>http://webserver/ReportServer</ReportServerUrl>
>> Note: Please backup above files to safe place before you try to modify
>> them. You may need to restart IIS if it is not take effect
>> After that, you may want to configure deploy server to
>> http://webserver/ReportServer in VS to test the situatioin.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>>
>> --
>> >Thread-Topic: Could not establish trust relationship with remote server.
>> >thread-index: AcYgX/vgGz1j0C1/RduYsSVDkkJvAQ==>> >X-WBNR-Posting-Host: 204.87.106.66
>> >From: =?Utf-8?B?TWlrZSBM?= <Cadel@.nospam.nospam>
>> >References: <18E8F20D-2CC6-4F76-9687-BE23EE3D3687@.microsoft.com>
>> >Subject: RE: Could not establish trust relationship with remote server.
>> >Date: Mon, 23 Jan 2006 13:00:04 -0800
>> >Lines: 18
>> >Message-ID: <A3C8E145-FFF3-4828-BC7F-C0C443BFCF63@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67357
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >I also tried without the s in https, but I still get the same error
>> message.
>> >
>> >http://webserver/ReportServer
>> >
>> >"Mike L" wrote:
>> >
>> >> Error comes up when I try to deploy RS to my web server, "The
underlying
>> >> connection was closed: Could not establish trust relationship with
>> remote
>> >> server." Web server has valid certificate, and I'm using https in my
>> >> connection.
>> >>
>> >> OverwriteDataSources: True
>> >> TargetFolder: Reports
>> >> TargetServerURL: https://webserver/ReportServer
>> >>
>> >> I'm able to see https://webserver/ReportServer through IE, and I see
the
>> >> folder Reports. I clicked on Reports and I see my old RS files.
>> >>
>> >
>>
>

No comments:

Post a Comment