dbTalk Databases Forums  

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

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2. in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sanctus
 
Posts: n/a

Default Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2. - 11-29-2007 , 05:21 PM






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 With Quote
  #2  
Old   
Nick Chan
 
Posts: n/a

Default Re: Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2. - 11-29-2007 , 09:19 PM






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
On Nov 30, 7:21 am, Sanctus <mch... (AT) hotmail (DOT) com> wrote:
Quote:
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 With Quote
  #3  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Windows 2003 SP1 won't let me set the lock pages in memory option...it says I need Sp2. - 11-30-2007 , 04:22 PM



Sanctus (mchi55 (AT) hotmail (DOT) com) writes:
Quote:
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.
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.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.