hi,
Currently i am working on SQL SERVER 2005 REPORTING SERVICE.After deploying the report i tried to subscribe it through mail.but im getting an error '"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Can anyone provide a solution for this
thanks
shoney
HI
I am having some issues with security and need some help. I have created some simple reports and even trying to use the adventure works examples. This issue that I have is that on BIDS I can view the report and on the mgt studio (however it keeps prompting me for a password) also when I try to schdule a report all I get is;
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) (Report Services SOAP Proxy Source)
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) (ReportingServicesLibrary)
Can someone please point me in the right direction??
Thanks
I am unable to create a subscription.
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)
Delievered by: Report Server E-Mail
SMTP: is enabled on IIS
Reporting Services Configuration Manager:
Email Setting: setup correctly
What else is it that I would need to check to get the subscriptions going?
Hello,
Im having a few issues with a report this should use dynamic connections.
I have a connection based on an expresssion which uses a switch to evaluate a input and select the appropriate connection string for the item.
This all works fine when in BIDS it happily switches between servers no problems. when i then deploy the report to a SSRS server and try and view it i get the following error:
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)
The format of connection string i am using is :
Data Source=<<server>>;Initial Catalog=staging;uid=<<username>>;pwd=<<password>>"
I have checked the report properties on the SSRS server and the connection correctly reports the conection is expression based and no credentials are required.
as a trouble shooting exersize i tryed a report which you just pass the connection string into instead of using a switch and got the same error
I have also tried it on another server and get the same problem.
Any suggestions?
Thanks
Paul