hello there, its a 32bit system, with 4GB installed, windows has detected the full 4 GB in system information etc.
The run_value of 0 means that AWE is actually not enable. Here are possible causes (these are both necessary)...
1. The account that runs the SQL Server 2005 Database Engine has not been assigned the Lock Pages in Memory option
2. sql server service was not re-booted
3.The Maximize data throughput for network application option of Network Connection in Control Panel is not selected.
"SQL Server supports Address Windowing Extensions (AWE) allowing use of physical memory over 4 gigabytes (GB) on 32-bit versions of Microsoft Windows operating systems." http://msdn.microsoft.com/en-us/library/ms187499.aspx
I don't believe you actually need to enable AWE if you only have 4GB of RAM. I believe you want to look at the /3GB switch..
"The 32-bit operating systems such as Windows 2000 and Windows Server 2003 provide access to 4-gigabyte (GB) of virtual address space. The lower 2 GB of virtual memory is private per process and available for application use. The upper 2 GB is reserved for operating system use. All operating system editions, starting with Microsoft Windows XP Professional and later, including Windows Server 2003, include a boot.ini switch that can provide applications with access to 3 GB of virtual memory, limiting the operating system to 1 GB. See your Windows documentation for more information on using the /3GB switch memory configuration."
Hope this helps.