<div>
Start-&gt; run<br />
Type gpedit.msc<br />
Expand down to <br />
Windows Settings-&gt;Security Settings-&gt;Local Policies-&gt;User Rights Assignments.<br />
Find the &quot;rule&quot; that you want to configure. Double Click on it and modify accordingly.<br />
<br />
In reality, as long as the user is part of the Administrators group, you should be fine.<br />
<br />
&nbsp;- Brugh<br />
<br />

</div>


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



<div>
Brugh,<br />
<br />
Thanks for the reply. &nbsp;The user is part of the administrator group and the group is part of all the policies except log on as a service. &nbsp;This one only has one user added and it is domain\besAdmin and the add group button is grayed out.<br />
<br />
Gabicus
</div>


Brugh,

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.

Gabicus

<div>
Brugh,<br />
<br />
Thanks for the info. &nbsp;That did help in trouble shooting the issue that I am having.<br />
<br />
Gabicus
</div>


Brugh,

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

Gabicus

<div>
<div class="content wysiwyg-content">
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.<br />
- Act as part of the operating system<br />
- Adjust memory quotas for a process<br />
- Log on as a batch job<br />
- Log on as a service<br />
- Replace a process level token<br />
<br />
My question is how do I check the SQL server machines local security policy for these permissions?<br />
<br />
Thank you<br />
<br />
<br />

</div>
</div>


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 machines local security policy for these permissions?

Thank you




Checking SQL Serever 2005 Machine's local policy.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.