Solved

Windows 8 - Login as administrator

Posted on 2014-02-12
4
570 Views
Last Modified: 2014-02-15
Experts,

Does anyone know why when I go to test an ODBC driver the system tell me I need to be signed in as an administrator.

I then login at the prompt with the same user ID and password and I am able to go in.  

Is there a way to initially log in as an administrator to avoid this happening?
0
Comment
Question by:morinia
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
becraig earned 500 total points
ID: 39854563
you can grant ODBC permissions to a specific user to avoid this:

You can grant Full Control permission to Domain Users/Users as needed by using Group Policy under the following registry key, please try the following steps:
1. Navigate to Computer Configuration\Policies\Windows Settings\Security Settings\Registry
2. Select Registry Key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
3. Add Domain users and grant Full Control permission to Domain Users / Users (Power User is not available in the case)


You can also disable UAC which I generally do not recommend.

List of registry keys and what they do available at:
http://technet.microsoft.com/en-us/library/dd835564%28v=ws.10%29.aspx
0
 
LVL 13

Expert Comment

by:Michael Machie
ID: 39854642
A couple options would suffice for this.

1) Make all Users admins by default
Go to the manage section of My Computer and add 'Everyone' as an admin to the local machine. This will remove all prompts for admin access requests for all programs - no more need to 'Run As Admin' or put your admin credentials in for any Service or program!

* R-Click the 'Computer' icon (in the start menu or the desktop icon
* Select 'Manage'
* Select 'Local Users and Groups'
* Select Groups'
* Dbl-click 'Administrators'
* Choose 'Add'
* Make sure the 'locations' box has the local machine name, if not, click 'Locations' and dbl-click your local machine name (you may need to select the + to expand and see it).
* Click 'OK'
* Under 'Enter the object names..." type in 'Everyone' (no quotes) and select 'Check names'. 'Everyone' should appear
* Click 'OK"
* '\Everyone' should be in the list now
* Choose OK and close all the windows.
NOTE: No matter who logs into your computer or which account is being used they will be a local admin.    

2) Make the specific individual a local admin so when they log in everything they do will be done as an admin.

* Follow the same steps as above but enter in the User account for the User you want to grant admin rights to.

***** If a Domain account, make sure the 'Location' is set to your Domain.
***** If a local User account make sure the location says the computer's name.

Hope this helps!
0
 
LVL 53

Expert Comment

by:McKnife
ID: 39854836
If the same credentials let you in, then the prompt for admin credentials is wrongly worded, that's all. MS does this in some situations: they require you to enter your own credentials to get some privileges that are stripped from your restricted account. Example: add a user to the group nework configuration operators. After logging out and in: he should be able to change network settings even as a non-admin. But alas, he will need to provide his OWN credentials again when doing so. A little madness in the method. So unless you turn off UAC, there is only compatibility shimming to stop this behavior. What is it? A comp. shim is produced by the MS tool ACT5 and tells the executable to use the highest-available token the user can get.
0
 
LVL 53

Expert Comment

by:McKnife
ID: 39861217
Out of interes: how did you solve it? In the ACL mentioned, domain users must have been in already, because you wrote, you could enter your own credentials once more to get in.
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now