Deployment Security Problem

Hi,
I am trying to deploy my reports to a new server running reporting
services w/ SQL Server 2000 on the local machine. The ReportServer web site
has anonymous access NOT checked and Windows Integration selected. I'm
logged onto my machine with my domain account and when I try to deploy my
reports in VS 2003 I get "The underlying connection was closed: Could not
establish trust relationship with remote server." I do NOT have "Require
SSL" turned on and I know it has something to do with the way my credentials
are being passed (or not passed). If I turn on the option to allow
anonymous access to the reportserver site then I get a message that my
IUSR_<machinename> has insufficient privleges to perform the actions, which
is fine I don't want anonymous access on anyway.
How do I resolve deploying reports to the report server with my domain
account? I used the same domain account to install SQL Server and Reporting
Services and I am a local administrator on the server.
Thanks, ChrisIn addition to what I've discovered...
I can take the same URL I'm using for the TargetServerURL property and
browse to the report server. I get a pop-up dialog box to input my
credentials and I'm authenticated fine. Based on Microsoft Knowledge Base
Article - 842517 it would seem that the login dialog box should appear, but
it doesn't and just the error "Could not
> establish trust relationship with remote server." appears. The local
administrators are "content managers" for reporting services and I am a
member of that group, though I don't think the deployment process is making
it that far.
Thanks, Chris
"Chris" <chrisf@.unr.edu> wrote in message
news:u03AZPxfEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to deploy my reports to a new server running reporting
> services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> has anonymous access NOT checked and Windows Integration selected. I'm
> logged onto my machine with my domain account and when I try to deploy my
> reports in VS 2003 I get "The underlying connection was closed: Could not
> establish trust relationship with remote server." I do NOT have "Require
> SSL" turned on and I know it has something to do with the way my
credentials
> are being passed (or not passed). If I turn on the option to allow
> anonymous access to the reportserver site then I get a message that my
> IUSR_<machinename> has insufficient privleges to perform the actions,
which
> is fine I don't want anonymous access on anyway.
> How do I resolve deploying reports to the report server with my domain
> account? I used the same domain account to install SQL Server and
Reporting
> Services and I am a local administrator on the server.
> Thanks, Chris
>|||Chris:
In IE's security settings for the zone, is User Authentication set to
automatic logon or prompt? You might want to check here (Tools ->
Options -> Security -> Custom Level (for the zone your report server
is in).
--
Scott
http://www.OdeToCode.com
On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
>Hi,
> I am trying to deploy my reports to a new server running reporting
>services w/ SQL Server 2000 on the local machine. The ReportServer web site
>has anonymous access NOT checked and Windows Integration selected. I'm
>logged onto my machine with my domain account and when I try to deploy my
>reports in VS 2003 I get "The underlying connection was closed: Could not
>establish trust relationship with remote server." I do NOT have "Require
>SSL" turned on and I know it has something to do with the way my credentials
>are being passed (or not passed). If I turn on the option to allow
>anonymous access to the reportserver site then I get a message that my
>IUSR_<machinename> has insufficient privleges to perform the actions, which
>is fine I don't want anonymous access on anyway.
>How do I resolve deploying reports to the report server with my domain
>account? I used the same domain account to install SQL Server and Reporting
>Services and I am a local administrator on the server.
>Thanks, Chris
>|||Hey Scott,
The IE zone setting changes don't have any affect. Visual Studio
continues to report the trust relationship error. I've tried both secure
and non-secure TargetServerURL properties.
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||Well, I changed the security on the web site to require secure connections
and installed the certificate from the server into my machine's certificate
store and the deploy worked. I don't quite fully understand why non-ssl
connections don't work, but turning ssl on and making sure the CA was
trusted fixed the problem. Could this have been a bug or is there some
requirement that a secure connection be used to deploy reporting service
objects?
Chris
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> Chris:
> In IE's security settings for the zone, is User Authentication set to
> automatic logon or prompt? You might want to check here (Tools ->
> Options -> Security -> Custom Level (for the zone your report server
> is in).
> --
> Scott
> http://www.OdeToCode.com
> On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >Hi,
> > I am trying to deploy my reports to a new server running reporting
> >services w/ SQL Server 2000 on the local machine. The ReportServer web
site
> >has anonymous access NOT checked and Windows Integration selected. I'm
> >logged onto my machine with my domain account and when I try to deploy my
> >reports in VS 2003 I get "The underlying connection was closed: Could not
> >establish trust relationship with remote server." I do NOT have "Require
> >SSL" turned on and I know it has something to do with the way my
credentials
> >are being passed (or not passed). If I turn on the option to allow
> >anonymous access to the reportserver site then I get a message that my
> >IUSR_<machinename> has insufficient privleges to perform the actions,
which
> >is fine I don't want anonymous access on anyway.
> >
> >How do I resolve deploying reports to the report server with my domain
> >account? I used the same domain account to install SQL Server and
Reporting
> >Services and I am a local administrator on the server.
> >
> >Thanks, Chris
> >
>|||I am using integrated security without ssl. I did have a problem once where
I went through an install without unchecking ssl and I was messed up. Don't
remember how I got out of the hole. However, I have done a couple of
installs since then and made sure to un-check ssl and everything went
smoothly.
Bruce L-C
"Chris" <chrisf@.unr.edu> wrote in message
news:%23hQmER7fEHA.140@.TK2MSFTNGP12.phx.gbl...
> Well, I changed the security on the web site to require secure connections
> and installed the certificate from the server into my machine's
certificate
> store and the deploy worked. I don't quite fully understand why non-ssl
> connections don't work, but turning ssl on and making sure the CA was
> trusted fixed the problem. Could this have been a bug or is there some
> requirement that a secure connection be used to deploy reporting service
> objects?
> Chris
> "Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
> news:jp1jh0dq2m82lm982j8rab8flnjjde59o2@.4ax.com...
> > Chris:
> >
> > In IE's security settings for the zone, is User Authentication set to
> > automatic logon or prompt? You might want to check here (Tools ->
> > Options -> Security -> Custom Level (for the zone your report server
> > is in).
> >
> > --
> > Scott
> > http://www.OdeToCode.com
> >
> > On Tue, 10 Aug 2004 12:54:27 -0700, "Chris" <chrisf@.unr.edu> wrote:
> >
> > >Hi,
> > > I am trying to deploy my reports to a new server running reporting
> > >services w/ SQL Server 2000 on the local machine. The ReportServer web
> site
> > >has anonymous access NOT checked and Windows Integration selected. I'm
> > >logged onto my machine with my domain account and when I try to deploy
my
> > >reports in VS 2003 I get "The underlying connection was closed: Could
not
> > >establish trust relationship with remote server." I do NOT have
"Require
> > >SSL" turned on and I know it has something to do with the way my
> credentials
> > >are being passed (or not passed). If I turn on the option to allow
> > >anonymous access to the reportserver site then I get a message that my
> > >IUSR_<machinename> has insufficient privleges to perform the actions,
> which
> > >is fine I don't want anonymous access on anyway.
> > >
> > >How do I resolve deploying reports to the report server with my domain
> > >account? I used the same domain account to install SQL Server and
> Reporting
> > >Services and I am a local administrator on the server.
> > >
> > >Thanks, Chris
> > >
> >
>

Deployment Problem

I get the following error while deploying on my local machine with my machin
e name or ip
A connection could not be established to the ReportServer http://machinename/Repor
tServer
If i deploy with localhost instead of machinename it works.
Any ideas why that happens.
Help would be appreciated.
ThanksI suggest you check your IIS configuration. Check the properties - web site
tab - advanced button of the Default website in IIS and see if you have
anything other than just "Default 80" under "Multiple identities for this
web site"
Tunji
"ReportFaqGuy" <anonymous@.discussions.microsoft.com> wrote in message
news:8160D89C-32CE-40C4-9A31-6066893C2048@.microsoft.com...
> I get the following error while deploying on my local machine with my
machine name or ip
> A connection could not be established to the ReportServer
http://machinename/ReportServer
> If i deploy with localhost instead of machinename it works.
> Any ideas why that happens.
> Help would be appreciated.
> Thanks
>sql

deployment and reports

Hi,

When I deploy a report i am assuming the report is deployed to the reporting service DB (ReportServer). Then when i try to view report in a browser I presume the following happens:

Navigate to http://localhost/Reports and click report you want to view

A web service call is made to retrieve report data from a DB eg Northwind

The data is the rendered based on the defined formatting in the RDL file and displayed in browser.

If this is correct does anyone known where the report is deployed to (DB or Web service) I cannot see the rdl files in any of these places and if I delete my project report viewing still works.

I know you can view all reports if you are in SQL management studio and go connect->reporting services but this is not a DB. Is this the web service and if so why cant i see files in IIS?

Thanks for replies

It's because they're not stored as files. When you deploy any files to the report server, they are stored in a table called Catalog and are serialized into an image column called Content.

Report Manager, Management Studio or whatever just connect to the web service and query it about which reports are stored in the database. The web service is basically the interface into the database.

Deploying to report server

I was able to deploy reports but just recently get the error "A connection
could not be made to the report server http://..../ReportServer".
Does anyone have any suggestions on what i may want to look at?
--
TabTry getting on the WebServer interface to see if the WebService is
listening, it is the same adress as you posted below,
HTH, Jens Süßmeyer.
"Tab" <Tab@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B5D22565-8181-4D45-BADA-20356A9EAABD@.microsoft.com...
>I was able to deploy reports but just recently get the error "A connection
> could not be made to the report server http://..../ReportServer".
> Does anyone have any suggestions on what i may want to look at?
> --
> Tab

Deploying Reports

this is about two related issues...
We tried to deploy by backing up the ReportServer DB on my XP dev box and
restoring over an existing ReportServer DB on a Server 2003 box. After the
restore, when trying to go to /localhost/reports we got "login failed for
'NT AUTHORITY\NETWORK SERVICE'. We then added that user to the ReportServer
Database. Then we got 'Cannot read ReportServer DB. Found Version unknown
expected Versions C.0.8.40.
So the first question is what went wrong?
The second question is: How are we supposed to deploy reports from an XP dev
box to a Server 2003 box? It can't be database backups and restores - it
must be by report but I can't find it in the docs. Can you point this out
in the docs or tell me how?
--
Regards,
Gary BlakelyHi Gary,
Thank you for your posting!
For the first issue, I think the root cause is that your Report Server
database is not match the Reporting Services binaries. The binaries are SQL
2005 and I wonder what's your Report Server databases in the dev box. If
it's SQL 2000, please follow the article to migrate the report server
database to SQL 2005:
If not, please make sure the Reporting Services is the same with the
service pack.
If your reporting services on your dev box is SQl 2005 SP1, I think you
need to upgrade your SQL 2005 on your server box to SP1 and then restore
the database.
For the deploy issue, as I mentioned above, you could use the backup and
restore to move all the reports to another server. But, the reporting
services should be the same.
Also, I think the best way for you is keep the report design project and
use the project to deploy the reports again.
Hope this will be helpful! If you have any questions or concerns, please
feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Wei,
All boxes are using ss2005.
I think that restoring over the ReportServer db on the target machine is not
a good idea because several programers will be deploying reports to that
machine and we can't wipe out work already on the target reporserver.
Can I deploy to another Server on the network. Seems that should be the way
to deploy.
But a second issue is the difference between XP and Server 2003. XP uses
MACHINE\ASPNET and Server2003 uses 'NT AUTHORITY\NETWORK SERVICE'. If we
don't use restore this should not be an issue because we are just deploying
reports. no?
Gary
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:8LOq3oAnGHA.4632@.TK2MSFTNGXA01.phx.gbl...
> Hi Gary,
> Thank you for your posting!
> For the first issue, I think the root cause is that your Report Server
> database is not match the Reporting Services binaries. The binaries are
> SQL
> 2005 and I wonder what's your Report Server databases in the dev box. If
> it's SQL 2000, please follow the article to migrate the report server
> database to SQL 2005:
> If not, please make sure the Reporting Services is the same with the
> service pack.
> If your reporting services on your dev box is SQl 2005 SP1, I think you
> need to upgrade your SQL 2005 on your server box to SP1 and then restore
> the database.
> For the deploy issue, as I mentioned above, you could use the backup and
> restore to move all the reports to another server. But, the reporting
> services should be the same.
> Also, I think the best way for you is keep the report design project and
> use the project to deploy the reports again.
> Hope this will be helpful! If you have any questions or concerns, please
> feel free to let me know.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hi Gary,
Thank you for the reply.
Deploy the report from your Visual Studio will be OK. The user is not a
issue. You could deploy the report from your designer to the server.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi Gary,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

Deployed Report

Hello,

When I run Build=> Deploy , where does the report go, I check Virtual Directory of ReportServer which is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer in my case and I do not see any file related to my report.

Thanks,

It depends on the Target URL specified under project in VS.Net

Deploy Report error?

I try to deploy report "rptInfo.rdl" and I receive this error;
A connection could not be made to the report server
http://localhost/ReportServer.
Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
What should i do to make this work?
Thanks.I reinstall my IIS and when i deploy again this report, I have a new error
message;
Error 1 The report server cannot open a connection to the report server
database. A connection to the database is required for all requests and
processing. 0 0
"GGill" wrote:
> I try to deploy report "rptInfo.rdl" and I receive this error;
> A connection could not be made to the report server
> http://localhost/ReportServer.
> Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
> What should i do to make this work?
> Thanks.|||One more error i have when i try to deploy the report
-- Build started: Project: Report Project1, Configuration: Debug --
Build complete -- 0 errors, 0 warnings
-- Deploy started: Project: Report Project1, Configuration: Debug --
Deploying to http://localhost/ReportServer
Error rsReportServerDatabaseUnavailable : The report server cannot open a
connection to the report server database. A connection to the database is
required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==================== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
"GGill" wrote:
> I try to deploy report "rptInfo.rdl" and I receive this error;
> A connection could not be made to the report server
> http://localhost/ReportServer.
> Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
> What should i do to make this work?
> Thanks.|||Looks like the Report Server web service cannot connect to the database. Is
this SQL Server 2005? Is so, run the configuration utility to set up a
backend database for RS. If it's SQL 2000, you may have to run Rsactivate to
provide correct database connection details.
Roman
--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"GGill" <GGill@.discussions.microsoft.com> wrote in message
news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> One more error i have when i try to deploy the report
> -- Build started: Project: Report Project1, Configuration:
> Debug --
> Build complete -- 0 errors, 0 warnings
> -- Deploy started: Project: Report Project1, Configuration:
> Debug --
> Deploying to http://localhost/ReportServer
> Error rsReportServerDatabaseUnavailable : The report server cannot open a
> connection to the report server database. A connection to the database is
> required for all requests and processing.
> Deploy complete -- 1 errors, 0 warnings
> ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> ==========> ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> "GGill" wrote:
>> I try to deploy report "rptInfo.rdl" and I receive this error;
>> A connection could not be made to the report server
>> http://localhost/ReportServer.
>> Unable to connect to the remote server
>> (Microsoft.ReportingServices.Designer).
>> What should i do to make this work?
>> Thanks.|||Back up. Make sure RS is working. Even with no reports deployed it will
still be there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"GGill" <GGill@.discussions.microsoft.com> wrote in message
news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> One more error i have when i try to deploy the report
> -- Build started: Project: Report Project1, Configuration:
> Debug --
> Build complete -- 0 errors, 0 warnings
> -- Deploy started: Project: Report Project1, Configuration:
> Debug --
> Deploying to http://localhost/ReportServer
> Error rsReportServerDatabaseUnavailable : The report server cannot open a
> connection to the report server database. A connection to the database is
> required for all requests and processing.
> Deploy complete -- 1 errors, 0 warnings
> ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> ==========> ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> "GGill" wrote:
>> I try to deploy report "rptInfo.rdl" and I receive this error;
>> A connection could not be made to the report server
>> http://localhost/ReportServer.
>> Unable to connect to the remote server
>> (Microsoft.ReportingServices.Designer).
>> What should i do to make this work?
>> Thanks.|||From SQL Server 2005 i am connecting to sql server 2000 database.
I try to connect to 'Reporting Services Configuration Manager' and i
received error message 'Provider load failure'.
How should i make RS work?
"Bruce L-C [MVP]" wrote:
> Back up. Make sure RS is working. Even with no reports deployed it will
> still be there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "GGill" <GGill@.discussions.microsoft.com> wrote in message
> news:6FBD875E-79E9-480C-9CE5-21D45B95AA0E@.microsoft.com...
> > One more error i have when i try to deploy the report
> >
> > -- Build started: Project: Report Project1, Configuration:
> > Debug --
> > Build complete -- 0 errors, 0 warnings
> > -- Deploy started: Project: Report Project1, Configuration:
> > Debug --
> > Deploying to http://localhost/ReportServer
> > Error rsReportServerDatabaseUnavailable : The report server cannot open a
> > connection to the report server database. A connection to the database is
> > required for all requests and processing.
> > Deploy complete -- 1 errors, 0 warnings
> > ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped
> > ==========> > ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========> >
> > "GGill" wrote:
> >
> >> I try to deploy report "rptInfo.rdl" and I receive this error;
> >>
> >> A connection could not be made to the report server
> >> http://localhost/ReportServer.
> >> Unable to connect to the remote server
> >> (Microsoft.ReportingServices.Designer).
> >>
> >> What should i do to make this work?
> >>
> >> Thanks.
>
>