SSRS 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.
Work Around:
In SSRS subscription, it is requires a Login to connect to the datasource to process the report when subscription will be occurring at its scheduled time.
Please refer to the steps below to solve the issue:
1. In report manager, click the arrow after the report, select Manage.
2. Click Data Sources in the left pane.
3. Select “A custom data source” option. And click option Credentials stored securely in the report server and provide credential information.
4. Then, select Use a Windows credentials when connecting to the data source.
5. Click on apply button.
1. In report manager, click the arrow after the report, select Manage.
2. Click Data Sources in the left pane.
3. Select “A custom data source” option. And click option Credentials stored securely in the report server and provide credential information.
4. Then, select Use a Windows credentials when connecting to the data source.
5. Click on apply button.
We also can use the shared data source which is having credential saved into report server.
There is an article about Subscriptions and Delivery, you can refer to it.
http://technet.microsoft.com/en-us/library/ms159762.aspx
http://technet.microsoft.com/en-us/library/ms159762.aspx
https://www.guest-articles.com/education/valid-des-1d12-braindumps-practice-test-pass-exam-with-confidence-10-11-2020
ReplyDelete