SQL Server 2005

Server 2008 – Reporting Services Error The permissions granted to user DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)

Written by Sam McGeown on 1/4/2010

Published under Microsoft

If you install Reporting Services on Windows Server 2008 (RTM or R2) and attempt to verify the installation by opening the http://SERVER/ReportServer site, you may well see the following message:

The permissions granted to user ‘MCGEOWN\Sam.McGeown’ are insufficient for performing this operation. (rsAccessDenied) Get Online Help

SQL Server Reporting Services

Additionally, you may be able to access the http://SERVER/Reports site, but will have no permissions:

How to configure Windows Server 2003 Enterprise and SQL 2005 to use more then 4GB RAM

Written by Sam McGeown on 9/10/2008

Published under Microsoft

32-bit processors have a limitation of only being able to directly address 4GB RAM - their architecture was never designed to address more. 64-bit processors get around that limitation by being able to us 64 bits to address RAM (potentially 16,777,216 GB), but what do you do if you have an application that won’t work on a 64-bit copy of Windows, but does need to utilise more than 4GB of RAM?