configuration error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » configuration error

configuration error

Rate Topic

Display Mode

Topic Options

Author

Message

RahulSingh

Posted Wednesday, August 08, 2012 4:42 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:59 AM
Points: 17, Visits: 93

hi,

while enabling xp_cmdshell from value 0 to 1 we are getting the following error when we try to reconfigure it the error is-

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

please help me resolve this error.

Thanks
Rahul Singh

Post #1341782

spaghettidba

Posted Wednesday, August 08, 2012 7:05 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 4,804, Visits: 8,074

I'm pretty sure you didn't change only xp_cmdshell from 0 to 1, but you (or somebody else before you) changed AWE from 0 to 1.
In order to use AWE, you need to grant the lock pages in memory privilege to the SQL Server service user account.
Is this a 32 bit instance?
Do you really want to turn AWE on?
If so, grant the privilege and cycle the instance.
If not, set AWE back to 0 and forget about it.

Hope this helps
Gianluca

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1341839

sandeep rawat

Posted Wednesday, August 08, 2012 7:13 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:06 AM
Points: 681, Visits: 298

Please check that u r having enough memory(Physical) at server.

see below links

http://blog.sqlauthority.com/2009/03/20/sql-server-awe-address-windowing-extensions-explained-in-simple-words/
http://www.modhul.com/2007/11/08/using-address-windowing-extensions-awe-with-sql-server/

Post #1341852

RahulSingh

Posted Wednesday, August 08, 2012 11:43 PM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:59 AM
Points: 17, Visits: 93

ya it's a 32 bit instance.
I have also enabled AWE from 0 to 1
After disabling AWE the query is working fine now...

Thanks for ur reply.

Post #1342390

spaghettidba

Posted Thursday, August 09, 2012 2:03 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 4,804, Visits: 8,074

I'm glad you sorted it out.
However, if it is a 32 bit server, you won't be able to use more than 3 GB of RAM without AWE enabled. Is that ok for you?

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1342444

sandeep rawat

Posted Thursday, August 09, 2012 2:08 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:06 AM
Points: 681, Visits: 298

kool

Post #1342446

« Prev Topic | Next Topic »

Permissions