Query execution failed for dataset DataSet_Name. (rsErrorExecutingCommand)

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

1.) Go to the ReportServer Database

2.) Drilldown to Tables and select the dbo.ConfigurationInfo

3.) Open the table and change the EnableRemoteErrors to TRUE in the Value column and run Execute SQL.

OR

In Management Studio, you must be logon on instance of report server and enable the property EnableRemoteErrors to see more details that error.

Connect Management Studio à in screen: Connect to Server, server type: Reporting Services àlocate the server instance in Server Name; after connected, in Object Explorer, right-click in server instance

àproperties

àadvanced tab

àEnableRemoteErrors set property like TRUE and restart internet browser.

OR

1.      Create a text file and copy the following script into the file.

Public Sub Main() 

  Dim P As New [Property]() 

  P.Name = "EnableRemoteErrors" 

  P.Value = True 

  Dim Properties(0) As [Property] 

  Properties(0) = P 

  Try 

    rs.SetSystemProperties(Properties) 

    Console.WriteLine("Remote errors enabled.") 

  Catch SE As SoapException 

    Console.WriteLine(SE.Detail.OuterXml) 

  End Try 

End Sub 

2.      Save the file as EnableRemoteErrors.rss.

3.      Click Start, point to Run, type cmd, and click OK to open a command prompt window.

4.      Navigate to the directory that contains the .rss file you just created.

5.      Type the following command line, replacing servername with the actual name of your server:

rs -i EnableRemoteErrors.rss -s http://servername/ReportServer