Archive for June, 2012

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

Advertisements

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

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/