We have application where web application needs to interact with SSRS. It is in different box. SSRS runs under different service account. Web Application runs under different service account differnt box. But for all the data source we would like to use “Credentials stored securely in the report server ” with “Use as Windows credentials when connecting to the data source” whenever I do that I get below error. The service account I am trying to use is Application server IIS App Pool account. Because we would like to use only one acccount for all the credentials. Log on failed. Ensure the user name and password are correct. I am typing right user name and password. Still I am getting this error. I would like to know what the prerequisites for this are. I am facing this issue in Report Manager when I try to change under the data source property. Is there anything I need to do for this. We have SSRS running as domain account "mydomain\ssrs_svc" and SQL2008 R2 running as domain account "mydomain\sql_svc". SQL2008 R@ is running AppName Instance name. SQL server name - > Host name - SqlServerBox - > Server - Windows 2008 64 bit Enterprice Anekm

See if that thread helps you http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fd7c491b-bd97-462c-87ee-bf66993b4071/Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Prasanna007, From your description, I am still confused about which account is specified to the data source in Report Manager. Generally, we can specify a single set of stored credentials that a report server uses to access external data for a report. So, please first make sure the account you specified as stored credential has been given at least the read access to the source database. In addition, the account must have Allow log on locally permission on the report server computer. For more information about Specifying Credential and Connection Information for Report Data Sources, please refer to http://msdn.microsoft.com/en-us/library/ms160330.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.