1

I received this request from a developer:

When I try to download *.rdl report files from myssrs_server/Reports I’m getting this error:

enter image description here

Would you be able to extend my permissions so I can download reports from all branches?

What is the minimal permission I should grant in order for him to get this done?

Any alternatives? (I was thinking about granting read only access to the reportServer database or something on those lines - but I don't want to make their lives too difficult )

I found this article very good regarding ssrs permissions:

SQL Server Reporting Services 2012 Permissions

Webpage were all the ssrs Predefined Roles are explained.

1

At the end, just so that I don't need to download the reports for them to edit, I have granted a very selective AD group with the contents manager permission, so that they can do their work.

any better alternative please post an answer or comment, I will review the situation accordingly.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.