AWE in SQL Cluster

Giganews Newsgroups
Subject: AWE in SQL Cluster
Posted by:  Cgal (cgallelli@newsgroups.nospam)
Date: Tue, 12 Jun 2007

I have a two node cluster with SQL Server 2005 that I am having difficulty
getting AWE to work.  I have granted the "lock pages in memory" right to the
domain account that the SQL Server service is running under on both nodes
and run the following commands to setup the AWE memory.

sp_configure 'awe enabled', 1
go
reconfigure with override
go
sp_configure 'max server memory','6144'
go
reconfigure with override
go

I get the following error message when these statements complete:

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.

Replies