Post reply

Error while enabling AWE

  • February 21, 2007 at 10:24 pm

    #153448

    Hi,

    I have done a new installation for sql server2005 Enterprise edition(32bit). the server is having 12Gb of ram and so I'm trying to enable AWE but getting errror

     

    Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

    Configuration option 'awe enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.

    Msg 5845, Level 16, State 1, Line 36

    Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

  • February 21, 2007 at 11:13 pm

    #691069

    Read the following blog/article for your answer...

    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://msdn2.microsoft.com/en-US/library/ms190730.aspx

     

    MohammedU
    Microsoft SQL Server MVP

  • February 22, 2007 at 3:31 am

    #691098

    You need to watch out for over zealous security templates in Group Policy which may seek to remove basic rights the sql server service needs. I've had some issues with the implementers of such policies ( it was a little like trying to explain to a child - but the types of person attracted to group policy is another matter < grin > )

    Neither of the above links are actually very useful, I assume you've set a domain account for the server ?, this must be set through SMS ( EM in 2000 ) NOT using the services property in computer management. There's a clear ms kb on this but I couldn't say where it is as I've known this for many years, I'm sure a quich search will find it.

    So. make sure you set your service accounts through sql, this should assign the correct rights and everyhting should work, subject to group policy of course.

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

  • February 22, 2007 at 4:36 am

    #691111

    thanks Mohammed.the article http://msdn2.microsoft.com/en-US/library/ms190730.aspx solved the problem.Adding the sqlgroup to the lock pages memory and a reboot solved the problem.

    Colin I had set the account while the installation only.

     

    Thanks all for your help.This forum really rocks!!!

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

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