Home > SSRS 2008, Troubleshooting, Windows 2008 R2 > Cannot Administrator SQL Server 2008 Reporting Services on Windows 2008 R2

Cannot Administrator SQL Server 2008 Reporting Services on Windows 2008 R2

http://technet.microsoft.com/en-us/library/cc512639.aspxI just finished installing SQL Server 2008 Reporting Services on Windows 2008 Server R2.  After all the settings were configured in Report Configuration Manager.  I went to http://servername/reports/, to find I don’t have any access.  I couldn’t see the “Site Settings” link, and the Content/Properties tabs were missing on Home Page.

Local Administrators are suppose to have access to http://servername/reports/.  I checked the ReportServer database on SQL Server to make sure nothing was wrong; namely checking the Users table to make sure BUILTIN\Administrators was listed in users that had access.

I also confirmed the report server install files logs to make sure no component was missed or such.  And than I looked into report server log file and I found possible issue with port 80 conflict.  I resolved this issue by turning off IIS however the original issue continued to persist.

Digging further into the configuration of Windows server I found “User Account Control (UAC)” was turned on. With UAC on even though I was part of Local Administrator group that part of my permission was not passed into the web browser.  Thus making it impossible to configure the reporting services but if I start Internet Explore with Right Click -> Run as Administrator option; I was able to access the administrator functionality with in Reporting Services.


  1. Wikipedia. User Control Account. Link.
  2. TechNet. User Account Control and SQL Server. Link.
  1. November 4, 2011 at 1:44 pm

    You saved me at least a day of banging my head against the wall. Thank you.

  2. November 6, 2011 at 6:30 pm

    Glad it helped you out.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: