SSRS Security

Posted on 2011-10-19
Last Modified: 2012-05-12
I have been tasked with providing one role for all users to use to get into any report in SSRS..Some people access report manager and the folders within directly.. Some people use an ASP.NET wibe site that passes a user name and password to SSRS and some people use a app that passes a user name and password and send a report to a PDF output.. They was ONE single Role that I would set up in SQL Server 2008 called Report_Role.. I want to add people based on their active directory windows name( everyone is something like LEX/cemith01) to this role so no matter how they access SSRS the can get in without having to provide a user name and password... The reports data comes from the same server but different databases and some use stored procs etc.. What do you recommend and is this possible? Remember the goal is to have anyone that I assign to the 1 role be able to read or write to a SSRS report in any folder.. Just basically be able to get to report manager so they can go to the folder they want, print a report or enter data into a report.
Question by:cheryl9063
    LVL 21

    Accepted Solution

    Go to site setting and create role and assign role to users.

    LVL 20

    Assisted Solution

    by:Marten Rune
    Create a domain group, and put users in the ad group, then create a login for the server for this group, create a user for this login in the database, create the role, and asign it to the user, grant permissions to the role. Example:
    USE master;
    USE mydb;
    CREATE ROLE rSupport;
    EXEC sp_addrolemember 'rSupport', 'MYDOMAIN\APPLICATION SUPPORT';
    GRANT SELECT, INSERT,UPDATE, etc ON Mytable TO rSupport;

    In your case mydb would be the reporting services db, and to let users create reports they need the rights to store them on disk where the web for reporting services reside, so let this domain group have apropriate ntfs permissions on the reports directories on the webserver also.

    Should cover it I think

    Regards Marten

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now