When trying to connect to an instance you may receive the following error message:
"Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process."
Lock pages in memory privilege has not been granted to the service account
Grant the right to lock pages in memory to the user account that SQL Server runs under. This can be done with the Group Policy console. See the link below for details:
http://technet.microsoft.com/en-us/library/ms190730.aspx
Note that you'll have to restart SQL Server afterwards. After SQL Server has restarted, sp_configure 'awe enabled' should then report 1.
Additional links that discuss this error:
http://sqlserver-qa.net/blogs/x64/archive/2008/05/21/4293.aspx
http://blogs.msdn.com/sqlprogrammability/archive/2007/01/20/trouble-shooting-query-performance-issues-related-to-plan-cache-in-sql-2005-rtm-and-sp1.aspx
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/a085f9d6-bc03-4ec6-add6-d0eaf621316e/
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy