Solved

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

Posted on 2011-09-19
10
603 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Dynamic Date Parameter 25 355
Ssrs disable the home lonk 1 79
SSRS sql paramater that works in Query Designer but not in the report 3 81
Install SSRS for developer 1 25
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 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