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
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP

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

SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.