web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Sales forum / Dynamics encryption ke...
Sales forum

Dynamics encryption key is wrong

(0) ShareShare
ReportReport
Posted on by Kevin L. 15

Hey, guys,
I have currently migrated a CRM 2015( v7.x) to D365 (v9.x). The CRM2015 had a data encryption with a key, because I secured it before.
Now, in the v9 system, I want to enter exactly this key, but it fails because it is supposed to be wrong.

The funny thing is that it worked successfully in an intermediate step during the migration (v8.2.3) with exactly this key.

Does anyone have any idea why or how I can solve the problem?

Greetings,
Kevin

PS: If you need more information, feel free to contact me

Categories:
Other
I have the same question (0)
  • Suggested answer
    Kevin L. Profile Picture
    Kevin L. 15 on at
    RE: Dynamics encryption key is wrong

    I have solved this poblem because this is an On-Prem System.

    I just copied with sql the line from the old SQL-Server to the new one and it worked.

    Hopfeully this helps someone in the future

  • jimmy07 Profile Picture
    jimmy07 35 on at
    RE: Dynamics encryption key is wrong

    I have the same encryption keyissue when upgrade v8.2 to v9.03. Could you please explain the detail steps to solve the issue?

    Thx.

  • Kevin L. Profile Picture
    Kevin L. 15 on at
    RE: Dynamics encryption key is wrong

    - Check that there's no key in table "OrganizationProperties"

    SELECT ColumnName, VarBinaryColumn FROM OrganizationProperties WHERE Id IN ( SELECT Id FROM Organization WHERE UniqueName = 'ORGNAME' ) AND ColumnName IN('SymmetricKeyPassword', 'SymmetricKeySource')

    - insert keys from old table

    INSERT INTO OrganizationProperties (Id, ColumnName, VarBinaryColumn) VALUES  
    ('ORG ID ', 'SymmetricKeyPassword', KEY AS BINARY) 
     
    INSERT INTO OrganizationProperties (Id, ColumnName, VarBinaryColumn) VALUES 
    ('ORD ID', 'SymmetricKeySource', KEY AS BINARY) 

  • jimmy07 Profile Picture
    jimmy07 35 on at
    RE: Dynamics encryption key is wrong

    Thx for the details.

    I tried another way before I received your answer. Thx anyway.

    It seems the problem is SQL 2017 related.

    Here is another user reported the same issue. (community.dynamics.com/.../upgrade-on-premise-8-2-to-9-0-errors )

    Microsoft's fix support.microsoft.com/.../sql-server-2017-cannot-decrypt-data-encrypted-by-earlier-versions, remember you must execute "DBCC TRACEON (4631,-1)" on your sql server, it was mentioned in the resolution.

    The fix is included in SQL 2017 latest CU.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Sales

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans