I am trying to move a report from one SQL 2008 server to another. I'm getting the rsInvalidDataSourceReference error but replacing the data source GUID with a guid from another report that does run on the new server is not fixing the problem. The data source is named the same thing on both servers - Is there something else I need to fix?

More info: Also - editing the report in designer and re-setting the data source does not work. When I add the data data source (shared) I can ping the connection Ok but I still get the error when I run the report...

Hello James S. 2011, Please take a look at this solution to see if this resolves your issue... Kind Regards, WCC44

Hi James, Generally, this error occurs when a path to a dependent item (for example, a shared data source) in a report cannot be resolved. Therefore, we need to re-specify the shared data source for the report. Please refer to the steps below: 1. Navigate the Properties page of the report in Report Manager. 2. Select the Data Sources tab in the left list. 3. Click the Browse button to select the data source. 4. Click Apply. For more information about this error, please refer to http://msdn.microsoft.com/en-us/library/bb326273.aspx About Managing Report Data Sources, please refer to http://msdn.microsoft.com/en-us/library/ms156018(v=SQL.100).aspx If you have any more questions, please feel free to ask. 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.