I'm running a single-server deployment of SharePoint 2013 and SQL Server 2014 with SSRS in SharePoint-integrated mode. When trying to set up a subscription for a new report, I get a popup saying:
Subscriptions cannot be created because credentials used to run this report are not stored.
Okay. So I pull up the properties for my data source, switch it to "Stored credentials", enter my
username/password (just for testing purposes) and click "
Test Connection", and get this error:
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Only Windows user credentials support 'Stored' or 'Prompt' options for a data extension that implements ITokenDataExtension for a report server configured in SharePoint integrated mode. Specify Windows credentials or configure the data source to use different options.
Fair enough. But when I tick "
Use as Windows credentials", I get this error:
The data extension cannot use Windows credentials because SharePoint does not use Windows authentication.
I don't know where to go from here. My SharePoint site is synced to the Active Directory for the domain on which it resides (which I don't have direct control over, I'm inside a larger managed development lab), the c2WTS service is installed and working, and I can run the report manually if the data source is set to "Windows authentication (integrated) or SharePoint user"; I did some googling and found that I can probably make the error go away if I rebuild my web app to use classic authentication instead of claims authentication, but since that's not the state of the production environment that's not a terribly useful fix. Isn't SSRS supposed to work with claims authentication anyway? Have I set something up wrong here?
Edit: I suppose it's worth mentioning that the data source is a SharePoint List type targeting the same site that the data source lives on.