We're starting to develop some SSRS reports using SSRS in SharePoint integrated mode. Environment consists of SharePoint 2013 with SQL Server 2012.
Things are working great, except for using subscriptions to deliver reports on a schedule. If our report data source is set to use Windows Authentication, we get the following error when trying to create a subscription:
Subscriptions cannot be created because credentials used to run this report are not stored. Provide credentials for the report datasource(s) or contact your administrator.
If we modify the data source to use a stored set of windows credentials, the subscriptions work fine. I should note that running the report manually when the data source is set to Windows Auth also runs fine.
Does anyone know if these is even supported? Doing some web research, I haven't been able to find any references to people doing it. If so, anyone know what logs I should be looking at to try and troubleshoot? Neither the ULS, nor the SSRS reports seem to be providing any info for me to base it on.