Windows 2003 SP1 won't let me set the lock pages in memory option...it says I need Sp2.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sanctus - 29 Nov 2007 23:21 GMT

Is there a way around this?

I have a SQL 2005 with 8 GB of memory that I want to set AWE on.
But the local security policy won't let me, it says:

This setting is not comaptiple with computers running Windows 2000
Service Pack 1 or earlier.
Apply group Policy objects containing this setting only to computers
running a later version of the operating system.

Why does it say Windows 2000 SP1 or earlier? I'm running on Windows
2003, sp1.

Reply to this Message

Nick Chan - 30 Nov 2007 03:19 GMT

i think u dont need to set awe in win2k3.i also think that if u wanna
use more than 4gb ram, u need enterprise version of win2k3 and sql

> Is there a way around this?
>
[quoted text clipped - 8 lines]
> Why does it say Windows 2000 SP1 or earlier? I'm running on Windows
> 2003, sp1.

Reply to this Message

Erland Sommarskog - 30 Nov 2007 22:22 GMT

> Is there a way around this?
>
[quoted text clipped - 8 lines]
> Why does it say Windows 2000 SP1 or earlier? I'm running on Windows
> 2003, sp1.

Don't know what that means, but it seems that some version information
in Windows have been corrupted. I think you should ask in a Windows
forum.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message