[tfs] report issue: An error has occurred during report processing.

Issue:

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

How to fix:

1. 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.

2. Update user password: Go to home page http://[servername]/Reports/Pages/Folder.aspx?ViewMode=List to change data source password to make sure it can connect to db.

Note: Report log file of report server. C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles this location may change according to your installation. here you can get clear idea of the error.

最后

以上就是轻松手链最近收集整理的关于[tfs] report issue: An error has occurred during report processing.的全部内容，更多相关[tfs]内容请搜索靠谱客的其他文章。