Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

configuration error Expand / Collapse
Author
Message
Posted Wednesday, August 8, 2012 4:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 5:49 AM
Points: 44, Visits: 179
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
Posted Wednesday, August 8, 2012 7:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:34 AM
Points: 5,014, Visits: 10,516
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


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1341839
Posted Wednesday, August 8, 2012 7:13 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:52 AM
Points: 716, Visits: 350
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
Posted Wednesday, August 8, 2012 11:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 5:49 AM
Points: 44, Visits: 179
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
Posted Thursday, August 9, 2012 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:34 AM
Points: 5,014, Visits: 10,516
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?


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1342444
Posted Thursday, August 9, 2012 2:08 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:52 AM
Points: 716, Visits: 350
kool
Post #1342446
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse