Link to home
Start Free TrialLog in
Avatar of susan1978
susan1978Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Mark Wills
Mark Wills
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial