Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2014-06-11 : 03:42:25
|
| HiWe have reporting services job schedule on sql server.few of them send mail through reporting services subscription .All was working fine but few days back mail are not begin sent i am get below error(all though jobs are executed on sql server).On trying to edit any subscription i get this 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 On inspecting reporting services log i get following error : The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.;Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specifiedlibrary!WindowsService_33!11cc!06/02/2014-02:00:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.;library!WindowsService_33!11cc!06/02/2014-02:00:13:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified.emailextension!WindowsService_33!f68!06/02/2014-02:00:13:: e ERROR: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. ---> |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-06-11 : 06:11:08
|
| Has the password expired for the user you set up the subscription with? try creating a new subscription with another valid user and schedule it for a few minutes in front...also, are there any issues with your mail server.We are the creators of our own reality! |
 |
|
|
|
|
|
reporting services subscription mail not begin sen