Was trying to upgrade the USD solutions, using USD Package deployer on the migrated CRM DB 9.0.3.X on-premise environment and got the below error.

Got the below error on Click on View log file.

“Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.“

This issue generally encounters, if the Encryption key doesn’t exist in CRM DB.

To check this, Open CRM and navigate to Settings -> Data Management

On Click of Data Encryption, will get the below error.

To resolve this issue, executed the below SQL update statement on CRM Config DB as we were not using HTTPS for CRMs Deployment.

UPDATE [MSCRM_CONFIG].[dbo].[DeploymentProperties]
SET [BitColumn]=1
WHERE ColumnName=’DisableSSLCheckForEncryption’

Now get the Encryption key from Source CRM. Copy & Paste in Activate Encryption Key and click on Activate as shown below.

Once activated, you can see the Encryption status as Active.

Restarted the process of upgrading USD solutions using Package deployer, that was successful.

Will explain the process of Upgrading USD Solutions in my next article.