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 |
|
josh2009
Yak Posting Veteran
81 Posts |
 Posted - 2010-09-21 : 09:23:14
|
| Hi,I just started using SSRS using SQL Server 2005. I've created several reports and have deployed these reports so they are available to use in Report Manager. I started playing around with subscriptions hoping to automate and schedule printouts for my end-users. I am trying to subscribe to this one report and have filled in the necessary fields in the subscription page but after getting everything filled in, when I hit OK, I get the ff msg - "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)". I've looked this up online and found a Microsoft Technet page on changing the setting of the data source I'm using and is as follows -1.Go to the Data Sources properties page of the report that you want to automate.2.For the Connect Using option, select Credentials stored securely in the report server. 3.In User Name and Password, type credentials that can be used to access the database. If you are using SQL Server as the data source, the user name must be valid for both logging on to the server and for accessing the database that contains the data for the report. 4.If the user name and password are credentials for a Windows account, select Use as Windows Credentials. If the credentials are for a SQL Server user login, do not select this check box.I have followed these tips and made the changes to my data source but I still get the same error msg.Any help will be greatly appreciated. Thanks. |
|
|
|
|
|
SSRS Subscription