I do not have enabled set /PAE and /3GB switch in my windows 2003 32 bit EE in my system.

I just enable AWE to 12 GB my performing above...

I have perform step 3 as guided in above replies.

http://sqlserverperformance.wordpress.com/2011/02/14/sql-server-and-the-lock-pages-in-memory-right-in-windows-server/

But in Task manager my memory is still not showing 12 GB ram.

Please see attachment.

Thank you for your reply.

I have did step 1 and step 2.

How can i perform step 3 ? Please elaborate.

How can we (Grant Lock Pages in Memory rights to the...

I have installed SP4 of SQl 2005 and problem has been resolved.

Thank you doctor.

Should i install Sp2 of SQl 2005

just want to add one more thing regarding this issue, that when we manually allocated the size, everything start working normally.

There is no accurate time for error , it comes any time.

Please see that the drive is not full . there is lot of space available .

I have noticed that i do not have any Service pack installed on my SQL...

Dear Atif

Problem is still there

but there is little bit progress which is

if i make both machines on domain error get fix.

but when i make both machine (both means actual...

03014477817

Dear Atif,

thanks u so much for your reply i have done this but problem is still there. help me

atif if you are in lahore can we talk thanks its urgent.

thanks

adeel...