hi, I have sQL Server 2005 on one of my server. I have around 10 reports created using BIDS connecting to different databases on different servers. All reports are deployed. Locally on the Reporting server, when i type http://localhost/Reportserver and click on the dir, i can see all the report linke and they open up perfectly fine. However when i try to access the same remotely (out of the reporting server from my desktop) IE, it gives me below error message. I have no clue what the underlying issue is. There are no errors or anything generated at Event Viewer or SQL Logs. How can i troubleshoot/fix this? An error has occurred during report processing. Cannot create a connection to data source 'DataSource1'. For more information about this error navigate to the report server on the local server machine, or enable remote errors

I got the solution to above. SSRS does not support extracting data directly from other data sources (Databases hosted on different servers). You need to create linked server and re-design your queries such that they are extracting data from the Linked Server table. This way the report works fine and you dont get the above error.