Server 2008 – Reporting Services Error The permissions granted to user DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)
Written by
Sam McGeown
Sam McGeownThis article is now 13 years old! It is highly likely that this information is out of date and the author will have completely forgotten about it. Please take care when following any guidance to ensure you have up-to-date recommendations.
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. And after all that, you may just stumble upon the fact that if you run Internet Explorer as Administrator, it will work as expected.