Archive for June, 2012

ERROR: The number of requests for XXXServer\XXXUser has exceeded the maximum number allowed for a single user

Posted: June 28, 2012 in SQLServer, SSRS
Tags: , ,
0

The reason for this error is the default value  for MaxActiveReqForOneUser key in RSREPORTSERVER.config file is 20 which need to be changed  to 0 (unlimited access) or increased to some higher value. After changing this setting IIS need to be reset in the reporting server machine.

Reportserver.config file exist in the following path (path may be little different based on the sql server reporting server version that is installed).

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

Reference:

http://www.sqlservercentral.com/Forums/Topic410741-162-1.aspx#bm507713

http://blogs.msdn.com/b/selvar/archive/2007/12/13/error-the-number-of-requests-for-xxxserver-xxxuser-has-exceeded-the-maximum-number-allowed-for-a-single-user.aspx

Branching/Merging using Perforce – Links

Posted: June 25, 2012 in Perforce
Tags: ,
0

Branching/Merging using Perforce Command-Line Client (P4) and Perforce Visual Client (P4V) …

http://kb.perforce.com/?article=4

http://filehost.perforce.com/downloads/media/branching/branching.html

Side-by-side installation of SQL 2008 R2 and SQL Server 2005

Posted: June 17, 2012 in SQLServer, Uncategorized
Tags:
0

Recently we faced issue with installing SQL Server 2005 in the db server that already has SQL Server 2008 R2 in it.

I tried installing all latest service packs from SP2 to Sp4 for SQL Server 2005 as mentioned in the reference link and it still not resolved the issue. So I was told to un install everything and reinstall SQL Server 2005 first and then SQL Server 2008 R2.

Installing multiple versions of SQL server in the same box is not always smooth. Let me know if any easy tips are available for this to follow.

http://support.microsoft.com/kb/913089

SP2: http://www.microsoft.com/en-us/download/details.aspx?id=9969

SP3: http://www.microsoft.com/en-us/download/details.aspx?id=14752

SP4: http://www.microsoft.com/en-us/download/details.aspx?id=7218

Reference:

http://sqlservermct.wordpress.com/2011/06/29/side-by-side-installation-of-sql-2008-r2-and-sql-server-2005/