Data Encryption Key

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.

ColumnNotes
IDOrganization ID
ColumnName

First row contains SymmetricKeyPassword

Second row contains SymmetricKeySource

VarBinaryColumncontains an encoded value for the encryption key

Leave a Comment

Your email address will not be published. Required fields are marked *