I'm having trouble accessing reports via the reporting services in SQL 2005.
I have a role created for the test account I'm using with Browser access. Th
e
only way I can see the report is if I give the test user local admin rights
on the SQL 2005 Report Server. Since I don't want to give all the users who
will use reports local admin rights on our SQL server is there any other way
around this?No, do not give the users local admin rights.
Report Server rights are really implemented as directory rights, not what
you are used to from SQL Server database rights. In the Books Online, look
up the topics in this hierarchy:
SQL Server Reporting Services
Managing and Working With Published Reports
Using Role-Based Security
That should tell you what you need to know.
RLF
"m968vuk" <m968vuk@.discussions.microsoft.com> wrote in message
news:48360D4F-3320-4064-A48D-03DE73D03396@.microsoft.com...
> I'm having trouble accessing reports via the reporting services in SQL
> 2005.
> I have a role created for the test account I'm using with Browser access.
> The
> only way I can see the report is if I give the test user local admin
> rights
> on the SQL 2005 Report Server. Since I don't want to give all the users
> who
> will use reports local admin rights on our SQL server is there any other
> way
> around this?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment