DISCLAIMER

This blog is independently maintained in my spare time. The views and opinions expressed on this website are my own and not the views and opinions of my employer.

Popular Posts

The number of requests for Server\User has exceeded the maximum number allowed for a single user Microsoft SQL Reporting Services & Team Foundation Server


Today one of my user faced new issue, While making the changes in Team Foundation Server dashboard, he was getting the following error:
The number of requests for Server\User has exceeded the maximum number allowed for a single user 

To resolve above SQL reporting server issue, Do the following,
Open Reportserver.config which is under ReportServer Directory & set the valule of MaxActiveReqForOneUser to 400 as shown below


 Restart Microsoft SQL Reporting Service to apply the changes,

MaxActiveReqForOneUser specifies the maximum number of simultaneous and in-progress connections that a single user can open to Report Manager. Once the limit is reached, further connection requests from the particular user are denied.