Microsoft Dynamics CRM 2013 introduces encryption of password fields in the SQL database.
Encryption is performed at the organization level and the keys are stored in the OrganizationProperties table in MSCRM_CONFIG. There are two rows for each organization. In each row the columns shown in the table below are populated.
Column | Notes |
ID | Organization ID |
ColumnName |
First row contains SymmetricKeyPassword Second row contains SymmetricKeySource |
VarBinaryColumn | contains an encoded value for the encryption key |