Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2011-09-19
10
605 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
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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