?
Solved

User does not have required permissions even if run IE as adminstrator

Posted on 2011-09-19
10
Medium Priority
?
618 Views
Last Modified: 2012-06-27
Windows 7 Ult x64  MSSQL Express 2008R2 with Advanced Services installed with all the default settings.
 
When browsing the Report Manger, http://computer_name/reports_sqlexpress, (IE9 x86 as Administrator) I get prompted for the user name and password, I enter the admin user and pw and get following error from Report Manager.
 
User 'computer_name\Admin' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
 
I've read various posts suggesting running the browser as administrator will at least allow you into the Report Manager.  Even though I'm logged on as the admin and run IE as Administrator I still get the error message.  I can connect to Report Manager (it is generating the permissions error message) but can't get in.  I've added the URL to IE trusted sites but makes no difference.
 
Any help here would be appreciated.
0
Comment
Question by:Bobmumm
10 Comments
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36558707
Did you set security at the site AND the folder level?
0
 
LVL 62

Expert Comment

by:gheist
ID: 36558750
Are you administrator of that particular server and that particular SQL instance?
0
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36558880
You can try to go here and follow the instructions from point 35.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36559875
Please assign permission to view folders and reports to view it.
0
 

Author Comment

by:Bobmumm
ID: 36561116
HendrikWiese

From where?  Running which application, what are the steps?  For your second comment on step 35 I said in my post that I'm running IE 9 x86 as an administrator.

gheist

Yes and Yes

PatelAlpesh

From where?  Running which application, what are the steps?


I cannot change any settings from within Report Manager.  The problem is that I cannot get into Report Manager even though I ran IE9 as an administrator.
0
 
LVL 21

Expert Comment

by:Hendrik Wiese
ID: 36561193
Point 35, should be done on the server side in iis if I remember correctly.
0
 

Author Comment

by:Bobmumm
ID: 36562105
HendrikWiese

There is no server side.  This is a stand alone Win 7 installation.  I'm not using IIS, why are you bringing that up?
0
 

Accepted Solution

by:
Bobmumm earned 0 total points
ID: 36564625
DO NOT run IE as adminsitrator, it does no good.  The problem is with UAC but you need to run it off.  In Control Panel\User Accounts turn off User Account Controls (UAC) then reboot the computer. You can then get into the Report Manager to make any needed changes see
http://msdn.microsoft.com/en-us/library/bb630430.aspx.

When done turn UAC back on and reboot again. You will then be able to get into Repoort Manager and you will not have to run IE as the administrator.
0
 

Author Closing Comment

by:Bobmumm
ID: 36591873
I'm accepting my own comment as the solution because it is the one that works?  No on eelse found the article as tfigured out the extra step of turning UAC off.  Turning UAC off was the critical step.
0
 

Author Comment

by:Bobmumm
ID: 36564640
That should read 'No one else found the article or figured out the extra step of turning UAC off.'
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question