I am working a single-server deployment of SharePoint 2013 and SQL Server 2014 with SSRS in SharePoint-integrated mode. When attempting to arrange a subscription for a brand new report, I get a popup saying:
Subscriptions can’t be created as a result of credentials used to run this report should not saved.
Okay. So I pull up the properties for my knowledge supply, swap it to “Saved credentials”, enter my username/password
(only for testing functions) and click on “Take a look at Connection
“, and get this error:
The present motion can’t be accomplished. The person knowledge supply credentials don’t meet the necessities to run this report or shared dataset. Solely Home windows person credentials assist ‘Saved’ or ‘Immediate’ choices for a knowledge extension that implements ITokenDataExtension for a report server configured in SharePoint built-in mode. Specify Home windows credentials or configure the info supply to make use of completely different choices.
Honest sufficient. However once I tick “Use as Home windows credentials
“, I get this error:
The info extension can not use Home windows credentials as a result of SharePoint doesn’t use Home windows authentication.
I do not know the place to go from right here. My SharePoint web site is synced to the Lively Listing for the area on which it resides (which I haven’t got direct management over, I am inside a bigger managed improvement lab), the c2WTS service is put in and dealing, and I can run the report manually if the info supply is about to “Home windows authentication (built-in) or SharePoint person”; I did some googling and located that I can most likely make the error go away if I rebuild my internet app to make use of traditional authentication as an alternative of claims authentication, however since that is not the state of the manufacturing atmosphere that is not a very helpful repair. Is not SSRS imagined to work with claims authentication anyway? Have I set one thing up mistaken right here?
Edit: I suppose it is price mentioning that the info supply is a SharePoint Record sort focusing on the identical web site that the info supply lives on.