Hi, all! I'm attempting to enable AWE memory allocation on one of our
servers. It has 4 gb of RAM, using 4 dual-core processors. My
understanding is that I need to enable AWE memory to take advantage of
all available memory. Is this true?

1.) Here's the script SQL Server produced when I attempted to turn on
AWE:

EXEC sys.sp_configure N'show advanced options', N'1'
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'awe enabled', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0'
RECONFIGURE WITH OVERRIDE
GO

2.) This produces the same error message for each statement:

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 for any suggestions, y'all.


--Don Kolenda



MS Sql Server LazyDBA home page