Error: (AWE) requires the 'lock pages in memory' privilege (52712)

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/