Saturday, December 31, 2016

Problem- Data Driven subscription-


Not able to create subscriptions for SSRS reports as it give the following error "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid"






Solution-

This error is due to the Windows authentication used for Data source Connection. SSRS requires a Login to connect to the data source to process the report when subscription will be occurring at its scheduled time. 
For this, it is required to store the credential in to Report Server or deploy the Data source with SQL Server Authentication. Use Custom Data Source and save the credential.





















No comments:

Post a Comment