Programaticly adding users to reporting services

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?
Who is Participating?
Mark WillsConnect With a Mentor Topic AdvisorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.