Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2012 Forums  Analysis Server and Reporting Services (2012)  Stored Credentials and Subscriptions

Author  Topic  cardgunner 326 Posts Posted - 2014-09-05 : 09:02:45 Currently we have all of our reports connection properties is set to Windows Integrated Security. The main reson for this is when the user runs the reports I can see them as a user thru the DB's Activity Monitor in Processes. In order for them to subscribe to the report I have to change the connecting properties to Credentials Stored Securely in the report Server. Now when they run the report either thru the subscription or on the run ALL users showup the as the same user. How can I allow subscriptions and still see thru the activity monitor who is running the report? CardGunner