If you are using Sql Server 2005 straight out of the box on 32bit Windows 2003 / 2000 and you would like Sql Server to be able to address more than 2Gb of RAM you have to enable AWE.
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.