SharePoint 2013 opens an RDL report with an error in the report server database. This error may be caused by a connection failure, a time-out, or insufficient disk space in the database



When you recently made the Reporting Services report, when you deployed to SharePoint, open the RDL report and often encountered a problem:

Error in Report server database. This error may be caused by a connection failure, a time-out, or insufficient disk space in the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: There was an error in the report server database. This error may be caused by a connection failure, a time-out, or insufficient disk space in the database. ---> System.Data.SqlClient.SqlException:Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding. ---> System.ComponentModel.Win32Exception: The pending operation is obsolete.

An error occurred within the report server database. This is due to a connection failure, timeout or low disk condition within the database. (Rsreportserverdatabaseerror) ", it seems that there is no access to connect the report Server database or the connection T o The report server database was time out.

Feel this problem because of the timeout problem, so try to modify the SharePoint server's ReportServer rsreportserver.config configuration,

C:\Program Files\Microsoft SQL Server\msrs11. Mssqlserver\reporting Services\ReportServer\RSReportServer.config

Put the Databasequerytimeout value inside, set a bit larger, from 120 to 1200,<add key= "Databasequerytimeout" value= "Max"/>

The problem has not yet arisen.

SharePoint 2013 opens an RDL report with an error in the report server database. This error may be caused by a connection failure, a time-out, or insufficient disk space in the database