SSRS SPIM subscriptions RRS feed

  • Question

  • 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 way through.

    As always, your help is greatly appreciated in resolving this matter.  Thanks!

    • Moved by Mike Walsh FIN Friday, March 11, 2011 3:35 PM ssrs q so bi forum (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    • Edited by Bryan Shaw Monday, April 4, 2011 3:14 PM bump
    Friday, March 11, 2011 3:14 PM

All replies