Monday, March 26, 2012

rsAccessDenied for every non local admin

Hi,
I'm having this strange problem while configuring RS on a Windows 2003
server. The SQL server DB exists on another machine. Whenever I visit the
report manager with the credentials used to install RS (this is also a local
admin account), everything is OK. When I use other credentials, the report
manager only shows the header "SQL Server Reporting Services". There is no
list of folders/reports available (the local admin can see this list), even
though i added the username as a RS system administrator. I think the role
assignment worked fine, because I can add users and grant permissions and
roles to other users with this account. What's even more weird is when i go
to /ReportServer/ I get the message "rsAccessDenied for user ...".
The IUSR account and the current account have permissions on the
\ReportServer folder and the \Reports folder.
Is there something else I missed? I'm testing this now because I need to
deploy some reports using RS in a production environment next week...
Help is much apreciated!
--
AndreasYes, as the local admin, go to the properties tab on the home page of
ReportManager. Here there is a security tab. Generally you want to give
everyone the browser role at this level. You can of course make this more
granular as you see fit.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:95C818F5-9E5E-4CAE-8691-47B9724384C6@.microsoft.com...
> Hi,
> I'm having this strange problem while configuring RS on a Windows 2003
> server. The SQL server DB exists on another machine. Whenever I visit the
> report manager with the credentials used to install RS (this is also a
local
> admin account), everything is OK. When I use other credentials, the report
> manager only shows the header "SQL Server Reporting Services". There is no
> list of folders/reports available (the local admin can see this list),
even
> though i added the username as a RS system administrator. I think the role
> assignment worked fine, because I can add users and grant permissions and
> roles to other users with this account. What's even more weird is when i
go
> to /ReportServer/ I get the message "rsAccessDenied for user ...".
> The IUSR account and the current account have permissions on the
> \ReportServer folder and the \Reports folder.
> Is there something else I missed? I'm testing this now because I need to
> deploy some reports using RS in a production environment next week...
> Help is much apreciated!
> --
> Andreas|||I'll try that
thx
"Daniel Reib [MSFT]" wrote:
> Yes, as the local admin, go to the properties tab on the home page of
> ReportManager. Here there is a security tab. Generally you want to give
> everyone the browser role at this level. You can of course make this more
> granular as you see fit.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Andreas" <Andreas@.discussions.microsoft.com> wrote in message
> news:95C818F5-9E5E-4CAE-8691-47B9724384C6@.microsoft.com...
> > Hi,
> >
> > I'm having this strange problem while configuring RS on a Windows 2003
> > server. The SQL server DB exists on another machine. Whenever I visit the
> > report manager with the credentials used to install RS (this is also a
> local
> > admin account), everything is OK. When I use other credentials, the report
> > manager only shows the header "SQL Server Reporting Services". There is no
> > list of folders/reports available (the local admin can see this list),
> even
> > though i added the username as a RS system administrator. I think the role
> > assignment worked fine, because I can add users and grant permissions and
> > roles to other users with this account. What's even more weird is when i
> go
> > to /ReportServer/ I get the message "rsAccessDenied for user ...".
> > The IUSR account and the current account have permissions on the
> > \ReportServer folder and the \Reports folder.
> >
> > Is there something else I missed? I'm testing this now because I need to
> > deploy some reports using RS in a production environment next week...
> >
> > Help is much apreciated!
> >
> > --
> > Andreas
>
>

No comments:

Post a Comment