Cannot create a connection to data source '<name of my datasource>'
I copied an old report and changed the data sources. The report works fine in the designer and on the report server. But when I run it from the server on which the database is located it gives me the following error. Works fine when I use 'Store credentials in report server'. tried anonymous login too. Doesnt work. An error has occurred during report processing. Cannot create a connection to data source '<name of my datasource>'. For more information about this error navigate to the report server on the local server machine, or enable remote errors Please help.
October 7th, 2010 4:54pm
check the below thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/067e649c-2e9d-49e2-9550-0488466105de/
October 7th, 2010 5:16pm
Thanks Sorna. I used a common admin user for both the report and database servers and it worked!
October 7th, 2010 9:11pm