Solved

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

Posted on 2011-09-19
10
608 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
[X]
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
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
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 
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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

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.   …
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

737 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