I have created a few reports which I have published to
the reporting server.
There is a group created something/Admins for example,
that was assigned to some users. I have the entire folder
that contains the reports in the manager set to allow
browser previleges to view reports within.
The problem is that even though the users are assigned to
that same group as the group name we set up for the
folder to view the reports, they get denied access to
view them. Oddly enough, if we add a single users NT id
to a role to view the reports in the folder, it works
fine.
So why is it if we provide a role to view reports
assigned to a specific users NT id, that works, yet using
the group they are assigned to does not work?
Thanks for the help.You might try doing an IISRESET after adding or removing the Group. It helped me.
Koby
"Adam" wrote:
> I have created a few reports which I have published to
> the reporting server.
> There is a group created something/Admins for example,
> that was assigned to some users. I have the entire folder
> that contains the reports in the manager set to allow
> browser previleges to view reports within.
> The problem is that even though the users are assigned to
> that same group as the group name we set up for the
> folder to view the reports, they get denied access to
> view them. Oddly enough, if we add a single users NT id
> to a role to view the reports in the folder, it works
> fine.
> So why is it if we provide a role to view reports
> assigned to a specific users NT id, that works, yet using
> the group they are assigned to does not work?
> Thanks for the help.
>
Showing posts with label admins. Show all posts
Showing posts with label admins. Show all posts
Sunday, March 11, 2012
Thursday, February 9, 2012
Access denied to everyone...
So, I'm having a crazy day. I have RS running on a development server. My development staff and I are all local admins on the machine with our domain accounts and we each have local accounts that are admins. All accounts, local and domain, have been setup on RS as everything. System Admins, Content Managers, etc. The entire dev staff is assigned to all roles.
Today, I tried to access the Report Manager to upload some reports only to discover that I have insufficient permissions to access anything. The front page comes up but even the site name isn't displayed. I did a trace on my local instance and when bringing up the front page 8 or so SPs are executed. On the development server only the first 2 are executed. None of the rest of the team sees anything different. Server and local workstation have been rebooted. Nothing.
None of the config files on the development server have been altered since installation and I can verify all role assignments through the database. So I don't know what would have happened in the last couple weeks to prevent us access.
I've searched the group and have seen several posts of a similar problem(insufficient permissions) but the advice is usually to grant extra permissions. The problem for us is that no one can access report manager to grant the permissions.
I'm stumped and figure I'll probably have to end up reinstalling(which sucks) but I thought I'd see first if anyone had any ideas as to what I can try.
HELP!!See if the following suggestion works for you:
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:OzfcJBHYEHA.3112@.tk2msftngp13.phx.gbl...
> Go to properties of Reports and ReportServer virtual roots, open security
> tab, select "Edit" under "authentication and access control", then make
sure
> anonymous in NOT checked. See if this helps.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
news:42C5F269-A748-428A-A6B1-F1F616312AB6@.microsoft.com...
> So, I'm having a crazy day. I have RS running on a development server.
My development staff and I are all local admins on the machine with our
domain accounts and we each have local accounts that are admins. All
accounts, local and domain, have been setup on RS as everything. System
Admins, Content Managers, etc. The entire dev staff is assigned to all
roles.
> Today, I tried to access the Report Manager to upload some reports only to
discover that I have insufficient permissions to access anything. The front
page comes up but even the site name isn't displayed. I did a trace on my
local instance and when bringing up the front page 8 or so SPs are executed.
On the development server only the first 2 are executed. None of the rest
of the team sees anything different. Server and local workstation have been
rebooted. Nothing.
> None of the config files on the development server have been altered since
installation and I can verify all role assignments through the database. So
I don't know what would have happened in the last couple weeks to prevent us
access.
> I've searched the group and have seen several posts of a similar
problem(insufficient permissions) but the advice is usually to grant extra
permissions. The problem for us is that no one can access report manager to
grant the permissions.
> I'm stumped and figure I'll probably have to end up reinstalling(which
sucks) but I thought I'd see first if anyone had any ideas as to what I can
try.
> HELP!!
Today, I tried to access the Report Manager to upload some reports only to discover that I have insufficient permissions to access anything. The front page comes up but even the site name isn't displayed. I did a trace on my local instance and when bringing up the front page 8 or so SPs are executed. On the development server only the first 2 are executed. None of the rest of the team sees anything different. Server and local workstation have been rebooted. Nothing.
None of the config files on the development server have been altered since installation and I can verify all role assignments through the database. So I don't know what would have happened in the last couple weeks to prevent us access.
I've searched the group and have seen several posts of a similar problem(insufficient permissions) but the advice is usually to grant extra permissions. The problem for us is that no one can access report manager to grant the permissions.
I'm stumped and figure I'll probably have to end up reinstalling(which sucks) but I thought I'd see first if anyone had any ideas as to what I can try.
HELP!!See if the following suggestion works for you:
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:OzfcJBHYEHA.3112@.tk2msftngp13.phx.gbl...
> Go to properties of Reports and ReportServer virtual roots, open security
> tab, select "Edit" under "authentication and access control", then make
sure
> anonymous in NOT checked. See if this helps.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Brian Harris" <BrianHarris@.discussions.microsoft.com> wrote in message
news:42C5F269-A748-428A-A6B1-F1F616312AB6@.microsoft.com...
> So, I'm having a crazy day. I have RS running on a development server.
My development staff and I are all local admins on the machine with our
domain accounts and we each have local accounts that are admins. All
accounts, local and domain, have been setup on RS as everything. System
Admins, Content Managers, etc. The entire dev staff is assigned to all
roles.
> Today, I tried to access the Report Manager to upload some reports only to
discover that I have insufficient permissions to access anything. The front
page comes up but even the site name isn't displayed. I did a trace on my
local instance and when bringing up the front page 8 or so SPs are executed.
On the development server only the first 2 are executed. None of the rest
of the team sees anything different. Server and local workstation have been
rebooted. Nothing.
> None of the config files on the development server have been altered since
installation and I can verify all role assignments through the database. So
I don't know what would have happened in the last couple weeks to prevent us
access.
> I've searched the group and have seen several posts of a similar
problem(insufficient permissions) but the advice is usually to grant extra
permissions. The problem for us is that no one can access report manager to
grant the permissions.
> I'm stumped and figure I'll probably have to end up reinstalling(which
sucks) but I thought I'd see first if anyone had any ideas as to what I can
try.
> HELP!!
Subscribe to:
Posts (Atom)