Solved

Windows 8 - Login as administrator

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
The goal of this Micro Tutorial is to help navigate beginning users with the app store on Windows 8. It will explain exciting features how to maximize your PC through these apps. This will be demonstrated using Windows 8 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

839 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