AWE, PAE and /3GB settings
Posted on 2009-06-29
I have read all the posts on AWE and PAE settings, but none of them quite answer my question...
First let me outline the context:
Windows Server 2003 R2 Standard Edition
SQL Server 2000 Standard Edition with SP4
Xeon 2.39GHz, 4GB RAM
Our SQL database is proving too large for the standard memory allocation, so it has been recommended that I explore the possibilities of increasing the amount of memory that SQL uses.
As a result, I have added the 3GB switch to the Boot file -
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /noexecute=optout /fastdetect/3GB
And I have run the script:
sp_configure 'show advanced options', 1
sp_configure 'awe enabled', 1
sp_configure 'max server memory', 3072
When restarting the SQL service, the error "Cannot use Address Windowing Extensions because lock memory privilege was not granted." shows, but I have added my windows account (we don't use specific SQL logins) to the policy list, along with the System account.
Can anyone tell me what I need to do now?