Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


Product Name

SQL Server

Product Version


Product Build Number


Event ID


Event Source




Symbolic Name


Message Text

Could not use Address Windowing Extensions because the 'lock pages in memory' privilege was not granted.

The Windows Lock Pages in Memory privilege is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). It determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk. On 32-bit operating systems, enabling this privilege when not using AWE can significantly impair system performance. Locking pages in memory is not required on 64-bit operating systems.

If you have system administrator permissions, use the Windows Group Policy tool (gpedit.msc) and grant this privilege to the account that SQL Server is running. For more information about how to enable Lock Pages in Memory, see How to: Enable the Lock Pages in Memory Option (Windows).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft