September 7, 2011 at 9:02 am
The following rights are required (and are established to a lesser or greater degree) by the installaion of SQL Server versions.
1 Adjust memory quotas for a process
2 Bypass traverse checking
3 Lock Pages in memory
4 Log on as a service
5 Perform volume maintenance tasks
6 Replace a process-level token
I can easily find the definitions of them online, but what i want to know is HOW they effect SQL Server i.e WHY they are needed.
4 & 5 are obvious, but I'm struggling with the others.
s
September 7, 2011 at 9:16 am
sqlbanana (9/7/2011)
1 Adjust memory quotas for a process
http://technet.microsoft.com/en-us/library/cc736528(WS.10).aspx
sqlbanana (9/7/2011)
2 Bypass traverse checking
http://technet.microsoft.com/en-us/library/cc739389(WS.10).aspx
sqlbanana (9/7/2011)
3 Lock Pages in memory
http://technet.microsoft.com/en-us/library/cc783969(WS.10).aspx
sqlbanana (9/7/2011)
6 Replace a process-level token
http://technet.microsoft.com/en-us/library/cc784623(WS.10).aspx
most of them are fairly obvious, for instance unless the sql server account has adjust memory quotas it cant dynamically manage memory for its process. Lock pages in memory can go hand in hand with this too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply