I need to know how I would use an Application Role to connect to my Sql Server Report Server (SSRS). I have an application that uses an Application Role to talk to the database. This works fine, as I can invoke the stored procedure, sp_setapprole, and my SqlConnection object now runs with the permissions of my application role. What I don't know how do to is to make a call to my Report Server with this same application role. As I understand, the Report server would need to invoke that same call to sp_setapprole before it could query the database. What is the recommended solution to have an application talk to an SSRS server while using an application role?

Hi Dave Gines New Dawn, Connecting to the DB using the application role in Reporting Services, there is a similar thread for your reference" http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/dff820cb-1c3f-4ea1-b829-6a53037c8b4b Thanks, LolaPlease remember to mark the replies as answers if they help.