see Microsoft KB article for information on using SQL Server in FIPS 140-2 compliant mode:

http://support.microsoft.com/kb/920995/

To configure encryption using SQL Server features:

From the SQL Server Configuration Manager GUI:

1. Expand SQL Server...