SQL Server 2005

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: Reporting Services Error -------------------------------------------------------------------------------- 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: You may also spend a good while checking DB permissions, IIS configurations, file permissions and so on.

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?