Programaticly adding users to reporting services

Posted on 2009-02-24
Last Modified: 2012-06-27
I am using forms authentication and reporting services for reports. Every time a user is added to the applications table i manuall enter the user name into the security of the reporting server and give him rights in reporting server.  THe user in the application can edit his username. When he does that it breaks his rights to to his folders because the username in reporting services stays the same. I am also running into other problems like the username might not be unique in the datbase which is okay but in reporting services it is not ok it causes a conflict. Is there any way for me to edit the username or add a new username in reporting service programaticly via store proc so that it matches with the username in my sql table? Is there a better way to handle this so there is less customer frustration nad less manual work?
Question by:susan1978
    1 Comment
    LVL 51

    Accepted Solution

    Maybe think about useing Role based security :
    or if really needed, then a custom extension to RS security :   -- which is part 1 of the above article.
    And there is an example on codeplex :!Security%20Extension%20Sample&referringTitle=Home
    And if you are a member of SQLMAG, then :

    Sorry about the links, but really it is the best way

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    How to increase the row limit in Jasper Server.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    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

    24 Experts available now in Live!

    Get 1:1 Help Now