Solved

How can I allow a user to login to a server without making him a administrator?

Posted on 2008-10-06
14
199 Views
Last Modified: 2010-03-17
I need to be able to allow a user to login to the server. I know that I can make him a domain administrator but is there another way to do this?
0
Comment
Question by:microsymplex
  • 6
  • 4
  • 2
  • +1
14 Comments
 
LVL 6

Expert Comment

by:RemcovC
ID: 22650878
Grant him the allow log on locally right (security policies)
0
 
LVL 71

Expert Comment

by:Chris Dent
ID: 22650883

If it isn't a Domain Controller you just need to ensure the user (or the required group) has the "Log on Locally" right in the local security policy.

Chris
0
 

Author Comment

by:microsymplex
ID: 22650896
It is a domain controller......
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 71

Expert Comment

by:Chris Dent
ID: 22650921

Then it would need to be done in the Default Domain Controller Policy. It's not something I'd recommend, DCs are very poor targets for user level access.

Chris
0
 

Author Comment

by:microsymplex
ID: 22650938
Yeah its actually for a tech that needs to do some testing without admin rights.  Where is the default domain controller policy?
0
 
LVL 71

Expert Comment

by:Chris Dent
ID: 22650974

Even user level access to a DC is a risk. But it's your system, so as long as you're happy with the risk :)

Linked to the Domain Controllers OU in Active Directory. If you have the Group Policy Management Console you should find it quite easily. Otherwise open the properties for the Domain Controllers OU in AD Users and Computers to access the Policy.

It's set under:

Computer Configuration / Windows Settings / Security Settings / Local Policies / User Rights Assignment

Then in "Allow Log on Locally".

Bear in mind that this policy effects all of your Domain Controllers.

Chris
0
 

Author Comment

by:microsymplex
ID: 22650978
Where do I find the local security settings on the server?
0
 
LVL 71

Expert Comment

by:Chris Dent
ID: 22651020

Start, Run, gpedit.msc.

Chris
0
 

Author Comment

by:microsymplex
ID: 22651042
duh... brain fart... ok but now allow logon locally is grayed out.
0
 
LVL 18

Expert Comment

by:sk_raja_raja
ID: 22651138
Why cant you make this user as a member of local admin of that server.....
0
 
LVL 71

Expert Comment

by:Chris Dent
ID: 22651161

Domain Controllers don't have local admin groups...

Chris
0
 
LVL 6

Expert Comment

by:RemcovC
ID: 22651218
domain controllers won't allow local policy change, you have to adjust de default domain policy

Go to Active Directory users and computers, find th OU in which your DC is, rightclick the OU and select properties.
Go to policy tab and edit the policy on this OU.
0
 
LVL 18

Expert Comment

by:sk_raja_raja
ID: 22651231
oops sorry chris..did not see microsymplex comment(It is a domain controller......)....:):):)
0
 
LVL 71

Accepted Solution

by:
Chris Dent earned 500 total points
ID: 22651259

> duh... brain fart... ok but now allow logon locally is grayed out.

Yeah, you need to be using the Default Domain Controllers Policy :) That's only where you find the local policy.

Chris
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Impact to changing AD username 2 24
Multiple Errors from DCDIAG 2 21
User Account issue 6 41
ADFS MSIS7065 error 8 15
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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