<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
Im new to the security side of SSRS and have a problem when creating a new subscription from a report, My reports data source uses SQL authentication and has an account will full access, the report runs sucsessfully viewing from SSMS -However, when I create a subscription for the report - I get the error message <br />
<br />
&nbsp; <br />
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. (rsInvalidDataSourceCreden<wbr />tialSettin<wbr />g) <br />
&nbsp;<br />
&nbsp;<br />
However I believe this error message to be incorrect as my SQL account is stored on the SQL server - is there something that Im missing?
</div>
</div>


Hi Experts

Im new to the security side of SSRS and have a problem when creating a new subscription from a report, My reports data source uses SQL authentication and has an account will full access, the report runs sucsessfully viewing from SSMS -However, when I create a subscription for the report - I get the error message 

  
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) 
 
 
However I believe this error message to be incorrect as my SQL account is stored on the SQL server - is there something that Im missing?

SSRS 2005 Security

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.