locked
Can not subscribe SSRS reports after windows update, Help ! RRS feed

  • Question

  • We have SSRS report email subscriptions working normally for a long time but stopped working recently. When we tried to subscribe manually, we got the following error message:

    "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"

    We don't think anything has changed except that we did a windows update. It could be that windows update changed the security behavior on credential authentication. I'm not familiar with this area. Could anyone help on this? Thank you in advance.



    • Edited by QQFA Wednesday, December 4, 2013 11:49 PM
    Wednesday, December 4, 2013 10:56 PM

Answers

  • Hello,

    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.

    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

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Marked as answer by Alisa Tang Thursday, December 12, 2013 9:38 AM
    Thursday, December 5, 2013 11:08 AM
  • Hello,

    Please select "Use a Windows credentials when connecting to the data source" option in report manager. Then, we can solve the issue.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Marked as answer by Alisa Tang Thursday, December 12, 2013 9:38 AM
    Monday, December 9, 2013 1:47 AM

All replies

  • Hello,

    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.

    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

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Marked as answer by Alisa Tang Thursday, December 12, 2013 9:38 AM
    Thursday, December 5, 2013 11:08 AM
  • Hi, Alisa

    Thank you so much for replying to my question. I followed your instruction and changed the shared data source to using stored credential. Now the subscription works! Thank you very much!

    I have a follow up question. In my SSDT, I also changed the shared data source to using the same stored credential but it didn't work (works with Windows Authentication). What should I do to make it work?

    Regards,

    Sunday, December 8, 2013 1:48 AM
  • Hello,

    Please select "Use a Windows credentials when connecting to the data source" option in report manager. Then, we can solve the issue.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Marked as answer by Alisa Tang Thursday, December 12, 2013 9:38 AM
    Monday, December 9, 2013 1:47 AM