CODEWITHSUNDEEP
reporting-servicestfs
A-Dastani
A-Dastani

Reputation: 1030

SQL Server Reporting Services in TFS

I receive the following error message when opening a TFS report:

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

Upvotes: 3

Views: 4950

Answers (2)

Hoody
Hoody

Reputation: 3381

Rebooting the TFS server and rebuilding the reporting databases fixed this for me.

Upvotes: 0

M.C.Rohith
M.C.Rohith

Reputation: 3750

This Error will pop up if the Dataset has the insufficient execute permission. Check that database your are using and give the execute permission if not.

Open Sql Server Mgmt Studio(SSMS) and log in through the user you are trying to access the report. Run the SQL Query in SSMS and make sure there is no error while running the script.

Run the report and For more help check in the log file of report server. C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles this location may change according to your installation. here you can get clear idea of the error.

Upvotes: 1

Related Questions