SQLTeam.com | Weblogs | Forums

Can't display data from other server after deplyment


#1

Hi,
I created a SSRS report that has a data source of a database in the local SQL Server. But, the dataset is actually a stored procedure to get data from other server by using a linked server. After deploy the report, I can get the report and display the data in http://localhost/ReportServer?%2FReport_08152017/Pages/ReportViewer.aspx within the local server. But, when I browse the report outside the server, in http://DevServer1/ReportServer?%2FReport_08152017/Pages/ReportViewer.aspx I can't get data. The error message is as following:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

But, if I use another dataset to query the data in the local database table(without using linked server to get the data from other server), I can display the data inside the outside the server.
Is something that I was missing from configure linked server to query the data in dataset1 and deploy report?

Thanks,

lw