SSRS 2005 Security

MrDavidThorn
MrDavidThorn used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical MAnager
Commented:
Hi,

  SSRS subscription running on " windows Authentication ".i suggest you to check your account has full rights in ssrs .

or

do the below

1. go to the SSRS report server link .
2. create a Datasource inside the "Data source Folder "
3. link the above data source inside your RDL properties  


http://msdn.microsoft.com/en-us/library/aa256058(v=sql.80).aspx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial