Path to Server Report?

Hi,
I have created a report with the report designer and deployed it
successfully to my http://localhost/Reports. I can browse and see my report
in Internet Explorer with the URL:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
Now if I try to open this report in my reportviewer control in a win
application (VS.NET 2005 RC1) I get "Request failed bla bla... Status 404:
Not Found". My settings (which I set in design time) for the reportviewer is:
ReportPath=/reportproject/frptSalesByFiscalYears
ReportServerURL=http://localhost/Reports
I use SQL Server 2005 september release.
Is there anything I am missing here?
Thanks
ThomasHi Thomas,
I'm thinking you have a permissions problem. When you set up the reporting
server, you probably set up the manager to run under a local system account,
and when you are accessing it from code, you are running under your domain
account.
Go into the report manager home page and go to into properties and make sure
you (your domain account) are added as a user that can access and run
reports.
Also make sure you, as a domain user, not in report manager, have rights to
the directory where the report is stored.
I hope that helps!
Chris
"Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
> Hi,
> I have created a report with the report designer and deployed it
> successfully to my http://localhost/Reports. I can browse and see my
> report
> in Internet Explorer with the URL:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
> Now if I try to open this report in my reportviewer control in a win
> application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
> 404:
> Not Found". My settings (which I set in design time) for the reportviewer
> is:
> ReportPath=/reportproject/frptSalesByFiscalYears
> ReportServerURL=http://localhost/Reports
> I use SQL Server 2005 september release.
> Is there anything I am missing here?
> Thanks
> Thomas|||Hi Chris,
I added my domain user in the report manager.
> Also make sure you, as a domain user, not in report manager, have rights to
> the directory where the report is stored.
> I hope that helps!
"Where the report is stored"? You mean my visual studio project directory?
My domain user is local admin so I guess I must have full rights for the
directory.
I still get the same error - 404 Not Found.
Any more ideas?
Kind regards
Thomas
"Chris Hastings" wrote:
> Hi Thomas,
> I'm thinking you have a permissions problem. When you set up the reporting
> server, you probably set up the manager to run under a local system account,
> and when you are accessing it from code, you are running under your domain
> account.
> Go into the report manager home page and go to into properties and make sure
> you (your domain account) are added as a user that can access and run
> reports.
> Also make sure you, as a domain user, not in report manager, have rights to
> the directory where the report is stored.
> I hope that helps!
> Chris
> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
> > Hi,
> >
> > I have created a report with the report designer and deployed it
> > successfully to my http://localhost/Reports. I can browse and see my
> > report
> > in Internet Explorer with the URL:
> > http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
> >
> > Now if I try to open this report in my reportviewer control in a win
> > application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
> > 404:
> > Not Found". My settings (which I set in design time) for the reportviewer
> > is:
> > ReportPath=/reportproject/frptSalesByFiscalYears
> > ReportServerURL=http://localhost/Reports
> >
> > I use SQL Server 2005 september release.
> >
> > Is there anything I am missing here?
> > Thanks
> > Thomas
>
>|||Hi Thomas,
I apologize, I should have paid more attention, you would get a 401 error if
you didn't have rights.
I have not used the report control in vs2005 so I can't be of much help.
A few things I would try, if you haven't already...
You could try to change the URL to
http://localhost/reports/pages/reports.aspx
Remove the / from the beginning of the report path.
Not sure what effect either of those will have
other than that, I've got nothing...
Chris
"Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
news:6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com...
> Hi Chris,
> I added my domain user in the report manager.
>> Also make sure you, as a domain user, not in report manager, have rights
>> to
>> the directory where the report is stored.
>> I hope that helps!
> "Where the report is stored"? You mean my visual studio project directory?
> My domain user is local admin so I guess I must have full rights for the
> directory.
> I still get the same error - 404 Not Found.
> Any more ideas?
> Kind regards
> Thomas
> "Chris Hastings" wrote:
>> Hi Thomas,
>> I'm thinking you have a permissions problem. When you set up the
>> reporting
>> server, you probably set up the manager to run under a local system
>> account,
>> and when you are accessing it from code, you are running under your
>> domain
>> account.
>> Go into the report manager home page and go to into properties and make
>> sure
>> you (your domain account) are added as a user that can access and run
>> reports.
>> Also make sure you, as a domain user, not in report manager, have rights
>> to
>> the directory where the report is stored.
>> I hope that helps!
>> Chris
>> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
>> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
>> > Hi,
>> >
>> > I have created a report with the report designer and deployed it
>> > successfully to my http://localhost/Reports. I can browse and see my
>> > report
>> > in Internet Explorer with the URL:
>> > http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
>> >
>> > Now if I try to open this report in my reportviewer control in a win
>> > application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
>> > 404:
>> > Not Found". My settings (which I set in design time) for the
>> > reportviewer
>> > is:
>> > ReportPath=/reportproject/frptSalesByFiscalYears
>> > ReportServerURL=http://localhost/Reports
>> >
>> > I use SQL Server 2005 september release.
>> >
>> > Is there anything I am missing here?
>> > Thanks
>> > Thomas
>>|||Hello Thomas,
Based on my experience, this issue usually occurs when reportpath or
reportserverurl is not set correctly.
reportserverurl shall be configured to
ReportServerURL=http://localhost/Reportserver
You configured to report manager URL which is not correct.
Hope this is helpful.
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.
--
| NNTP-Posting-Date: Wed, 02 Nov 2005 14:33:16 -0600
| From: "Chris Hastings" <chrshstngs@.comcast.net>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| References: <EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com>
<Qe6dnQvBwb1MlPTeRVn-uA@.comcast.com>
<6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com>
| Subject: Re: Path to Server Report?
| Date: Wed, 2 Nov 2005 14:33:23 -0600
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <J6udnUJ5E5QRv_TeRVn-rw@.comcast.com>
| Lines: 83
| NNTP-Posting-Host: 24.245.14.181
| X-Trace:
sv3-ep9KVa+bnR1eNiBRahlXfqV+hbAYwe2Jiqg18L54I7k/OgepIYapxZIyj4Ce04mb5tF+CbVt
5o9zkru!fvMc03S2mqFhzWUae09DI18YFTUwBmEmfxySRFwMDAwKEf+n8nWLbxftvxSkhxineDt6
WRKz2LYH!My8=| X-Complaints-To: abuse@.comcast.net
| X-DMCA-Complaints-To: dmca@.comcast.net
| X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
| X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
| X-Postfilter: 1.3.32
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POST
ED!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:55604
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Thomas,
| I apologize, I should have paid more attention, you would get a 401 error
if
| you didn't have rights.
| I have not used the report control in vs2005 so I can't be of much help.
| A few things I would try, if you haven't already...
| You could try to change the URL to
| http://localhost/reports/pages/reports.aspx
| Remove the / from the beginning of the report path.
| Not sure what effect either of those will have
| other than that, I've got nothing...
| Chris
|
| "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
| news:6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com...
| > Hi Chris,
| >
| > I added my domain user in the report manager.
| >
| >> Also make sure you, as a domain user, not in report manager, have
rights
| >> to
| >> the directory where the report is stored.
| >> I hope that helps!
| >
| > "Where the report is stored"? You mean my visual studio project
directory?
| > My domain user is local admin so I guess I must have full rights for the
| > directory.
| >
| > I still get the same error - 404 Not Found.
| >
| > Any more ideas?
| >
| > Kind regards
| > Thomas
| >
| > "Chris Hastings" wrote:
| >
| >> Hi Thomas,
| >> I'm thinking you have a permissions problem. When you set up the
| >> reporting
| >> server, you probably set up the manager to run under a local system
| >> account,
| >> and when you are accessing it from code, you are running under your
| >> domain
| >> account.
| >> Go into the report manager home page and go to into properties and
make
| >> sure
| >> you (your domain account) are added as a user that can access and run
| >> reports.
| >> Also make sure you, as a domain user, not in report manager, have
rights
| >> to
| >> the directory where the report is stored.
| >> I hope that helps!
| >> Chris
| >>
| >> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in
message
| >> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
| >> > Hi,
| >> >
| >> > I have created a report with the report designer and deployed it
| >> > successfully to my http://localhost/Reports. I can browse and see my
| >> > report
| >> > in Internet Explorer with the URL:
| >> >
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSa
lesByFiscalYears
| >> >
| >> > Now if I try to open this report in my reportviewer control in a win
| >> > application (VS.NET 2005 RC1) I get "Request failed bla bla...
Status
| >> > 404:
| >> > Not Found". My settings (which I set in design time) for the
| >> > reportviewer
| >> > is:
| >> > ReportPath=/reportproject/frptSalesByFiscalYears
| >> > ReportServerURL=http://localhost/Reports
| >> >
| >> > I use SQL Server 2005 september release.
| >> >
| >> > Is there anything I am missing here?
| >> > Thanks
| >> > Thomas
| >>
| >>
| >>
|
|
|