Database Mail XPs - Error: "...(AWE) requires the ''lock pages in memory'' privilege which is not currently..."
-
Hi
I have a clustered SQL Server 2005 environment where I want to enable database mail. When I try to send mail:
Msg 15281, Level 16, State 1, Procedure sp_send_dbmail, Line 0
SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Database Mail XPs' by using sp_configure. For more information about enabling 'Database Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.
So when I try to enable it:
sp_configure
'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
Error occur:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
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.
Configuration option 'Database Mail XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.
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.
What can be the problem?
-
Please check this.
1. Type secpol.msc from run prompt
2. Navigate to user rights assignment
3. you will see a list of permissions in the right hand side
4. check for lock pages in memory and check if the permission for the user is there and if not give permission to users necessary.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Thanks, I will try that.
-
It didn’t work. The same error message is still there
-
you have to give permission for the user account starting sql server services. have you did that?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
I have added all the accounts i can think of. Still the same error.
-
I think you have 2 separate issues...
1) Enabling the mail XPs. I think this has worked fine from the results you have shown.
2) The AWE message. I think you have AWE enabled for your instance. SQL is detecting this and also detecting the service account does not have the 'lock pages in memory' right in Windows, which is prompting the message.
Try using the mail XPs and see if they work. Remember you must set up a mail profile before the XPs will work (see BOL for details).
If your server has more than 4GB memory and you want to use AWE, then the service account needs to have the 'lock pages in memory' Windows right. The Windows boot.ini should also have the /PAE switch, and if server memory is under 16 GB then it also should normally have the /3GB switch.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
Hey you do you want to use your mail XPs when 2005 has database mail with it which does a more powerful job to send mail than the previous mailing system.
Ed,
He says that he has already given permission for all users to have lock pages in memory. May be does a logoff required for it to take effect. if so he can try that and possibly succeed
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply