Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Error processing linked servers in SSRS

Author  Topic 

tdorflinger
Starting Member

3 Posts

Posted - 2010-04-28 : 14:18:42
Hello, I am getting the error below after I deployed a report built in BIDS to SSRS. In my data set I am retrieving data from two servers that are linked and everything works fine in both Management Studio & Visual Studio. The problem only occurs on the Reporting Service. I think this must be an authentication or credentials issue since I can access either server individually. However I am not a DBA. Has anyone seen this problem or have any ideas? Thanks.

"An error has occurred during report processing.
Query execution failed for data set 'DataSet1'."
   

- Advertisement -