SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server Reporting Services (SSRS) Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




download SQL Server 2016
download SQL Server 2014



Subscriptions cannot be created because the credentials used to run the report are not stored

While trying to create a Reporting Services report subscription in SQL Server 2008 R2 Report Manager web application, I got the following SQL Server Reporting Services subscription 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.

SQL Server Reporting Services subscriptions cannot be created

To overcome this report subscription error, I goto Home of the Report Manager web site, then displayed Data Sources folder. When you display the Properties tab of the Data Source that the related report is using, check the section "Connect using"

You can store credentials here so that the Reporting Services report subscription can use use saved credentials for connecting to database. Choose the option : "Credentials stored securely in the report server" and provide a valid username and password

SQL Server Reporting Services data source credentials for report subscription

After you validate the stored credentials using Test Connection buton, you can use the shared data source while creating subscriptions in SQL Server Reporting Services







SSRS-Reporting Services

SQL Server Articles

Reporting Services Blog

SQL Server Reporting Services Forums

SQL Blog

Certification Exams Blog










Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems