CRM On-Premises Data Encryption Error–Disable for Testing


 

I had encountered the following error while trying to update a CRM User’s Business Unit in a Dynamics CRM 2015 On-Premises TEST environment – it prevented me from making any updates to a CRM user:

Data Encryption error – There are encrypted fields in the organization database, but the data encryption feature isn’t activated…

image

I then received the following error when trying to activate Data Encryption in the TEST environment:

Error – The HTTPS protocol is required for this type of request.

image

Since this CRM TEST environment does not need HTTPS – here is a way to by-pass this error (NOT recommended for PRODUCTION CRM):

Referencing this article – ran the following SQL to disable SSL Checking for Encryption  via MS SQL Server Management Studio and then perform an IISRESET:

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

image

I then encountered two errors trying to activate Data Encryption:

1. The new encryption key does not meet the strong encryption key requirements – easy fix so instead of the value “test” – I set it to a value that would work

image

 

2. Please select an account that is a member of the PrivUserGroup – another easy fix, added PrivUserGroup{GUID} membership to my CRM Login via Active Directory Users Console

image

 

Finally success.  Issue solved – I can move on to my testing!

 

image

 

Contact me if you need some Dynamics 365 Sales/CRM or InsideView assistance.

Frank Lee, Dynamics 365 Business Solutions MVP Sales/CRM San Francisco
Workopia, Inc – Maximum User Adoption!

About Microsoft Dynamics 365 / CRM

Microsoft Dynamics 365 / CRM specialist. 12 Times Awarded Microsoft MVP - Business Solutions / CRM
This entry was posted in CRM On Premise, Dynamics 365, Microsoft CRM, Microsoft Dynamics CRM, MS CRM, Troubleshooting and tagged , , . Bookmark the permalink.

2 Responses to CRM On-Premises Data Encryption Error–Disable for Testing

  1. J.D says:

    Hi Frank,

    can you share how you disabled data encryption? I can’t find anything on the web.
    Appreciated

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s