Limit the active number of connections within Reporting Services

November has been a busy month with the conference season.......Teched and SQLBits which I attended and of course PASS,

and I will provide an update on these in my next blog

A quick tip as a result from a question from a customer who wanted to restrict the amount of connections that a user can have to a report server that is to be hosted on an extranet.

 You can limit the number of active requests per user by editing the following key within the RSReportServer config file located in

C:\Program Files\Microsoft SQL Server\MSRS10.INSTANCE\Reporting Services\ReportServer

<Add Key="MaxActiveReqForOneUser" Value="20"/>

 The default value is 20 and can be changed to a number that suits your requirements



Published Tuesday, December 1, 2009 10:28 PM by Testas
Filed under:


No Comments