Report Creators need to be local Admin? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Report Creators need to be local Admin?

A user in my team created a report by using Report Services 2005 from "Business Intelligence Developer Studio" tool. When he tried to "Deploy Report Project", he got error: "insufficient permissions to…".
After I add him into Local Administrator group, he is able to deploy his report.
Do I have to grant Admin permissions to all users who need to create report on Report Services? Are there any other permissions can help the users?
Add everyone into Local Admin group is very risk.
Thanks for recommendation,
George Jiang
Is this on a production server? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |