If you want to use Address Windowing Extensions (AWE) in SQL Server 2005/2008, you have to enable the Windows policy Lock Pages in Memory option. But this option is disabled by default. You have to use Windows Group Policy editor to enable it. The details are here:
How to: Enable the Lock Pages in Memory Option (Windows)