error while subscribing SSRS report

  • Hi - I would like to email subscribe my SSRS report and when i am trying to create new subscription getting the below error;

    "subscription cannot be created because the credentials used to run the reprot are not stored". I am using shared datasource and in Datasource properties I have checked the "Credentials stored securely in the report server" button. Am using Domain account and also checked the below options too:

    - Use as Windows credentials when connecting to the data source

    - Impersonate the authenticated user after a connection has been made to the data source

    Can somebody please help me to resovle this.



  • Hi...

    The foremost thing is essential to store credentials on Report Server for subscriptions to work..

    Now..if your report datasource is Sql Server DB..then just put user name and password info for Sql Server DB and check the option to store credentials on Report Server...

    But if your are using Windows Credentials..then place the login credentials of the system on which the source database / cube is and just check...the option..use this as Windows Credentials...No need to check another check box...for authentication...

    It will work...:)



Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply