Checking SQL Serever 2005 Machine's local policy.

Posted on 2007-10-17
Last Modified: 2010-03-19
I have created a user for a SQL 2005 server and I am supposed to check to make sure that the user has the following permissions.
- Act as part of the operating system
- Adjust memory quotas for a process
- Log on as a batch job
- Log on as a service
- Replace a process level token

My question is how do I check the SQL server machines local security policy for these permissions?

Thank you

Question by:GabicusC
    LVL 9

    Expert Comment

    Start-> run
    Type gpedit.msc
    Expand down to
    Windows Settings->Security Settings->Local Policies->User Rights Assignments.
    Find the "rule" that you want to configure. Double Click on it and modify accordingly.

    In reality, as long as the user is part of the Administrators group, you should be fine.

     - Brugh


    Author Comment


    Thanks for the reply.  The user is part of the administrator group and the group is part of all the policies except log on as a service.  This one only has one user added and it is domain\besAdmin and the add group button is grayed out.

    LVL 9

    Accepted Solution

    Sorry, you said local.. my bad.

    Try going into Administrative Tools->Local Secruity Policy and make the changes there.  :)

     - Brugh

    Author Comment


    Thanks for the info.  That did help in trouble shooting the issue that I am having.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now