Is it possible for a report subscription to be executed with the subscriber's windows authentication credentials?
We have a need for a single report to have sensitive information available to high level personnel in our organization. We need for that data to be blank for normal users.
The report works wonderfully well when the user clicks on it within th SP report library. The sensitive information shows up for the VP, but not for the normal user. When we have tried to do a subscription, however, because SSRS SPIM requires
that the credentials be stored, I am not sure what to do.
We have setup an unattended SSRS user account. We have other reports that do not require security, so we are using a SQL Server login for those and those subscriptions work great.
Win 2008 R2, SQL Server 2008 R2, SharePoint 2007 and everything is patched up to the latest releases and service packs. No hot fixes have been applied. IIS 7 is in place and working well. We have verified that Kerboros is working the whole
As always, your help is greatly appreciated in resolving this matter. Thanks!
View Complete Post