I have SSRS 2005 on Server A. I have data on Server B. A linked server exists on both servers to pull data. The report works just fine in Visual Studio.
After I've deployed the report to SSRS on Server A, I am getting an error that states "An error has occurred during report processing. Cannot create a connection to data source 'VIP_Data' "
(VIP_Data is a data source that points to the data on Server B.)
I assume this issue has to do with setting security to Windows Authentication and that my credentials are not being passed to Server B.
What is the work-around?