<div>
Try this:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms190673.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190673.aspx</a>
</div>


Try this:

http://msdn.microsoft.com/en-us/library/ms190673.aspx [http://msdn.microsoft.com/en-us/library/ms190673.aspx]

<div>
OEEnigma: he is running server 2003 standard so it means sql will only be able to see what the OS sees which is no more than 4 gb
</div>


OEEnigma: he is running server 2003 standard so it means sql will only be able to see what the OS sees which is no more than 4 gb

<div>
I am aware of that and it was indicated in the doc. I guess I should have been a little more verbose. Thanks for the reminder.
</div>


I am aware of that and it was indicated in the doc. I guess I should have been a little more verbose. Thanks for the reminder.

<div>
Thanks guys I thought that might be the case. &nbsp;I don't believe there are upgrades available for Windows 2003 anymore. &nbsp;I'll have to research the upgrade paths.<br />
<br />
Thanks again.
</div>


Thanks guys I thought that might be the case.  I don't believe there are upgrades available for Windows 2003 anymore.  I'll have to research the upgrade paths.

Thanks again.

<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
I have Windows Server 2003 Std 32-bit with SQL Server 2008 installed. &nbsp;My system has 6GB of memory installed but only 3.5GB can be accessed by windows. &nbsp;Can I activate AWE to give more memory to SQL Server?<br />
<br />
I've been trawling through the forum looking for someone with a similar setup but can't find it. &nbsp;I'm beginning to think it can't be done.<br />

</div>
</div>


Hi Guys,

I have Windows Server 2003 Std 32-bit with SQL Server 2008 installed.  My system has 6GB of memory installed but only 3.5GB can be accessed by windows.  Can I activate AWE to give more memory to SQL Server?

I've been trawling through the forum looking for someone with a similar setup but can't find it.  I'm beginning to think it can't be done.


Windows 2003 Std with SQL 2008 can I use AWE

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).