Solving SQL Reporting Server and UAC Error

A couple of weeks ago I was setting up a new laptop and had installed SQL Reporting Services 2012. Everything on the install went surprising quite easy. I opened a browser and typed in the classic http://localhost/reports and after a few minutes the following error message appeared.

“User ‘DOMAIN\user’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.”

The crazy thing is that I am a domain administrator so why will this not work? After spending some time looking around and trying different solutions I found a pretty simple resolution.

1. Run your browser in administrator role. (figure 1)
runasadmin1(figure 1)

2. Enter this in the url : http://localhost.Reports (figure 2)
(note: Do Not use http://<<Server Name>>/reports)

localhost(figure 2)

3. Go to the Folder Settings (figure 3) and assign role browser (figure 4) and content manager to your administrator (figure 5).
(note: Make sure you do this at the root folder)

SSRS_figure3(figure 3) SSRS_figure4(figure 4) SSRS_figure5(figure 5)

4. Close browser and try launching regularly.

And that’s it!

Looking for quality web hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , , | Posted under Programming/Coding | RSS 2.0

Author Spotlight

David Bauernschmidt

I live in the historical triangle of Virginia where I am married with two daughters. I have spent over 13 years working for a Fortune 500 company in the computer area. I started in VB 6.0 and by the time I ended my employment I was supervising a development team where we built many web applications. When my first daughter was born I wanted to spend more time with her so I left and became a programmer analyst for local government as well as launch my own company. Since then I have grown James River Webs into a profitable web design and application company helping small businesses create a big presence on the internet. As an employee I have created web application used by citizens and other companies. I enjoy fly fishing, and spending time with my family. I also enjoy learning new approaches and development tools when it comes to developing applications.

2 Comments on Solving SQL Reporting Server and UAC Error

  1. oleg says:

    David…I am having hell of a time with Arvixe trying to setup the reports. We have installed Report Builder (RB) on our end, built a dummy test report, and no matter what we do, we either get eerror that we don’t have sufficient rights to preview the report (in RB), or when we upload into Report Server, its just blank. Lots of emails back and forth between us and Arvixe, but it seems no-one understands what they are doing…its been over a week…is there anyway you can help?? … or if you have done something different that we are not doing…or something we need to tell Arvixe to do (because again, they don’t seem to understand SSRS and how to set it up)…please help 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *