A little old but a good starting point nonetheless:
http://msdn2.microsoft.com/en-us/library/aa302434.aspx

Just remember to be consistent about what you use to perform the encryption
and the SQL Server service account both during setup and when you change
passwords. Getting locked out of your own DB sounds funny but really isn't.

joe.