Hi, I just upgraded a server from SQL 2005 to SQL 2008. We are running Reporting Services. When I try to view my report I get this error: An error has occurred during report processing. (rsProcessingAborted) The data source 'My_DataSource' cannot be found. (rsDataSourceNotFound) The database is available and I can query it just fine via T-SQL Any thoughts?

Hi, Update the Datasource string in your report DataSource connection string. You can get your SQL 2008s datasource string in SQL Server Management Studio 2008, and then open your report shared data source windows and update its connection strings datasource. Thanks, Jerry

Hi ,Make sure that you have deployed the data source. Why donot you try to deploy once again the same data source with correct credntials to the server by enabling OverWriteDataSources property to TRUE. It just deploythe data source on the server, if it already exists it will just overwrite with new deployed data sourceI hope it will work.Please let me know if you face any errors.Thanks,SatishDataBase Designer

I'm facing the same issue. The datasource string in the rdl file is fine. There are no changes there. However the moment I make changes to the rdl and Update in Report Manager the error crops up. Any ideas?