Easy methods to: Permit the Lock Pages in Memory Alternative (Windows) to: Permit the Lock Pages in Memory Preference (Windows) Hi there, Could anyone stage me to step-by-step recommendations for establishing SQL Server 2005 in an active-passive cluster to make use of over 2 GB of RAM? Ideal now,
Microsoft Office 2010 Professional, the server I am taking a look at seems to be employing about 1.6 GB of memory,
Office Ultimate 2007 Key, but you can find 8 GB of RAM while in the server. I've tried the measures here but maintain having the error under ERROR:Tackle Windowing Extensions (AWE) usually requires the 'lock pages in memory'privilege which is not currently present with the access token of the process.I even experimented with rebooting the server,
Microsoft Office Professional Plus 2007, but I still get the error,
Microsoft Office Professional Plus 2007, and when I check the choice in sp_configure, it still has a 0 for the run value of 'awe enabled'. If permissions are involved, could you include the exact types of permissions and where to set them? Because this is a cluster, I don't know if I should go by the logon user specified when I check the MSSQLSERVER service inside Services control panel (versus setting it utilising the Cluster Administrator - I'm not sure). Thanks in advance for any help. If even more info is needed,
Windows 7 Pro Key, please let me know. jrdevdba