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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 reporting services subscription mail not begin sen

Author  Topic 

anoop_mig25
Starting Member

20 Posts

Posted - 2014-06-11 : 03:42:25
Hi

We 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 specified

library!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!
Go to Top of Page
   

- Advertisement -