Post reply

Msg 5845, Level 16, State 1, Line 1 Address Windowing Extensions (AWE) requires the 'lock pages in memory'

  • April 23, 2008 at 12:27 pm

    #121828

    Hi, Getting the below error while defragmenting the index. Please let me know if anyone has come across this and know the solution

    Msg 5845, Level 16, State 1, Line 1 Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

    Thanks in advance

    SNT

  • April 23, 2008 at 12:32 pm

    #806236

    well I've seen the lock pages error but not when rebuilding an index. I guess you may have run out of physical memory. Have you infact set this permission?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 23, 2008 at 1:16 pm

    #806270

    The account running the SQL services has to have the ability to lock pages in memory. As Colin stated, I've never seen that particular message but the response to the error leads me to believe that you have rights issues..This'll detail how to do it

    http://technet.microsoft.com/en-us/library/ms190730.aspx

    -- You can't be late until you show up.

  • April 23, 2008 at 11:30 pm

    #806369

    thanks a lot for the response by mistake I copied the other error. Below is the correct error details

    The index "d_1f3b03c58002" (partition 1) on table "sdm_text" cannot be reorganized because page level locking is disabled. [SQLSTATE 42000] (Error 2552)

    thanks

    SNT

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply