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!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment