Tuesday, March 20, 2012

cant see Report manager page

Hi Friends
we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !!
all they can see is "sql server reporting services" text nothing else. no reports and no models ertc.,

i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create reports off report server page.
Thanks for your help.From the main page, select the properties tab, then select the security sub-tab. You can grant the necessary permissions to any group or user there.|||Thanks for that Brian. I just tried that but did not work.
our domain name is "yabba.co.nz" so i added domain by clicking "new role assignment" but to no avail.
so i tried add one of users ,who is having this problem like "yabba.co.nz\Peter" but got following error
The user or group name 'yabba.co.nz/Peter' is not recognized. (rsUnknownUserName)

any ideas please.
Thanks for your help|||You should be specifying the user or group name the same way you would for an ACL, such as for the file system. If you are using a domain user, the report server machine must be a part of that domain.|||Thank you very much Brian.
That really helped . now all our users could view report manager page and they can view and run reports now :)

one thing remained though, they cant see "Report builder" link .i tried to assign all roles (i.e. browser,content manager etc.,) but still did not help.
any ideas on this one.
Thanks for your help again :)|||

The user must have "Execute Report Definition" permission. This is a system level permission that can be configured from the "Site Settings" link at the top of Report Manager.

|||Thank you very much Brian.
That worked like a charm. Thanks for all your help :)

No comments:

Post a Comment