I'm trying to understand the interaction between the SSRS DatabaseQueryTimeout (set at the server level, defaults to 120 - does this only apply to connections to the ReportServer internal database?)

RsReportServer.config Configuration File

and the RDL Query.Timeout setting (set in individual RDL, defaults to 30)

Setting Time-out Values for Report and Shared Dataset Processing (SSRS)

If I have an RDL with no setting defined, will it timeout at 30s or 120s?

  • WAITFOR DELAY '00:00:45': SELECT 100 AS DemoResult;
    – billinkc
    Jan 22, 2020 at 18:01
  • DatabaseQueryTimeout: "This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property." It seems that if RDL has not specific timeout, it uses this value.
    – McNets
    Jan 22, 2020 at 18:28

1 Answer 1


The answer is in your first link:

DatabaseQueryTimeout - Specifies the number of seconds after which a connection to the report server database times out.

This setting only applies to the connections from the RS services to the RS databases, not for individual reports to their data sources. This makes sense given:

This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property

What if your data source is not SQL, what if it is Oracle or MongoDB or some other data source? This setting wouldn't exist for that connection object.

The answer to your question is, with no setting defined your timeout would be 30s.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.