Solved

Windows 8 - Login as administrator

Posted on 2014-02-12
4
588 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 54

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 54

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
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…

749 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