How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr. I recently worked on a SQL Server Reporting Service issue, and I thought of documenting it so that (maybe :)) it will be helpful for someone !!!

Latest Post – Fix Report Server Cannot Open A Connection Error ConfigMgr | SCCM HTMD Blog (anoopcnair.com)

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

See the error message. How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr.

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

Patch My PC
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr,
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

Logged into SQL server and ran the same report from the server as per the below note on the error “For more information about this error navigate to the report server on the local server machine.”

I ran the same report from the SQL server, and the error got more clear now 🙂

An error has occurred during report processing. (rsProcessingAborted)
               Query execution failed for dataset ‘DataSet3’. (rsErrorExecutingCommand)
                        Timeout expired. The timeout period elapsed before completion of the operation or the server is not responding

I tried to change “Site Setting” in the SSRS web portal as mentioned below, but that didn’t help.

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

Launched the console  and navigated through Reporting -> Reporting Services -> \\Servername -> All reports – > Properties of “Software 02D – Computers with a specific software product.”

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

As the error was pointing to “DataSet3” change the timeout option of “DataSet3” from 30 to 1800.

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

And that is it !!! The issue is resolved  !!!

How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr
How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

4 thoughts on “How to Fix Resolve SCCM SSRS Timeout Expired Error ConfigMgr”

  1. which console are you talking about? can’t find any console for reporting services exept for reporting services configuration manager.
    I am running sql 2005 and I’m facing the same issue.
    thanx

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.