Monday, February 20, 2012

Reporting Services, Don't see report

When I access the report from the localhost (Which holds the SQL & IIS Server
for Reporting Services) - I can see everything. However, if I go to another
machine and access the "reports" - I can see the report manager, the folder,
everything - until you click on the report - then in the "report body frame"
- it just simply says - "Page not found"... Not an authentication error, just
as if I typed a URL which doesn't exist. The top frame still shows the
report manager links, etc...
Any advise is extremely appreciated...RS works using roles. You have to assign a user or a group to a role. When
you are on the local machine you most likely are logged in as someone who
has administration rights on the machine, this puts you automatically into a
role since the administrators local group is by default given a role. What I
do is create local groups and add domain groups and users to the local
group. Then I assign the group to a role. Read up on roles in the books on
line.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chester Flake" <Chester Flake@.discussions.microsoft.com> wrote in message
news:BAAC66ED-2844-459F-B83C-8BF747439BE8@.microsoft.com...
> When I access the report from the localhost (Which holds the SQL & IIS
> Server
> for Reporting Services) - I can see everything. However, if I go to
> another
> machine and access the "reports" - I can see the report manager, the
> folder,
> everything - until you click on the report - then in the "report body
> frame"
> - it just simply says - "Page not found"... Not an authentication error,
> just
> as if I typed a URL which doesn't exist. The top frame still shows the
> report manager links, etc...
> Any advise is extremely appreciated...
>|||Bruce,
Thank you for responding to my question... However, when I am asked to
authenticate from another machine - I use an account with admin rights... I
GET the Reports "Home page" - when I click on an actual report - I get the IE
"Page cannot be displayed" problem.
So - I type in http://myreportserver/reports
it comes up with the typical reports homepage... then I click on a folder,
see the reports... click on the report and the LOWER FRAME (Which holds the
reports) shows "Page cannot be displayed" like as if I typed a bad URL...
The top half still shows all the tab sheets for the report.
Chester Flake, MCSE, MCDBA, MCSD, MCAD, MCSA, MCDST, MCP, MCT
"Bruce L-C [MVP]" wrote:
> RS works using roles. You have to assign a user or a group to a role. When
> you are on the local machine you most likely are logged in as someone who
> has administration rights on the machine, this puts you automatically into a
> role since the administrators local group is by default given a role. What I
> do is create local groups and add domain groups and users to the local
> group. Then I assign the group to a role. Read up on roles in the books on
> line.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chester Flake" <Chester Flake@.discussions.microsoft.com> wrote in message
> news:BAAC66ED-2844-459F-B83C-8BF747439BE8@.microsoft.com...
> > When I access the report from the localhost (Which holds the SQL & IIS
> > Server
> > for Reporting Services) - I can see everything. However, if I go to
> > another
> > machine and access the "reports" - I can see the report manager, the
> > folder,
> > everything - until you click on the report - then in the "report body
> > frame"
> > - it just simply says - "Page not found"... Not an authentication error,
> > just
> > as if I typed a URL which doesn't exist. The top frame still shows the
> > report manager links, etc...
> >
> > Any advise is extremely appreciated...
> >
> >
>
>|||Another possibility has to do with credentials. Click on the datasource (via
Report Manager) and go to the credentials tab and see how it is setup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chester Flake" <ChesterFlake@.discussions.microsoft.com> wrote in message
news:3D588362-F06E-4583-93F7-CEBD62506D45@.microsoft.com...
> Bruce,
> Thank you for responding to my question... However, when I am asked to
> authenticate from another machine - I use an account with admin rights...
> I
> GET the Reports "Home page" - when I click on an actual report - I get the
> IE
> "Page cannot be displayed" problem.
> So - I type in http://myreportserver/reports
> it comes up with the typical reports homepage... then I click on a folder,
> see the reports... click on the report and the LOWER FRAME (Which holds
> the
> reports) shows "Page cannot be displayed" like as if I typed a bad URL...
> The top half still shows all the tab sheets for the report.
> Chester Flake, MCSE, MCDBA, MCSD, MCAD, MCSA, MCDST, MCP, MCT
>
> "Bruce L-C [MVP]" wrote:
>> RS works using roles. You have to assign a user or a group to a role.
>> When
>> you are on the local machine you most likely are logged in as someone who
>> has administration rights on the machine, this puts you automatically
>> into a
>> role since the administrators local group is by default given a role.
>> What I
>> do is create local groups and add domain groups and users to the local
>> group. Then I assign the group to a role. Read up on roles in the books
>> on
>> line.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chester Flake" <Chester Flake@.discussions.microsoft.com> wrote in
>> message
>> news:BAAC66ED-2844-459F-B83C-8BF747439BE8@.microsoft.com...
>> > When I access the report from the localhost (Which holds the SQL & IIS
>> > Server
>> > for Reporting Services) - I can see everything. However, if I go to
>> > another
>> > machine and access the "reports" - I can see the report manager, the
>> > folder,
>> > everything - until you click on the report - then in the "report body
>> > frame"
>> > - it just simply says - "Page not found"... Not an authentication
>> > error,
>> > just
>> > as if I typed a URL which doesn't exist. The top frame still shows the
>> > report manager links, etc...
>> >
>> > Any advise is extremely appreciated...
>> >
>> >
>>

No comments:

Post a Comment