Currently we have all of our report's connection properties 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 connection properties to Credentials Stored Securely in the reporting services. Now when they run the report either thru the subscription or on the run ALL users show up the as the same user.
How can I allow subscriptions and still see the actual windows user thru activity monitor?
CardGunner