Changing email gives Data Encryption error

(0) Share

Report

Posted on by Hakan

Hi, imported users to an on-premise CRM with links to their AD. When I checked the imports, I see that the e-mails were blank and now I can't change the e-mails. I Receive Data Encryption error. the error log says "Can not open SQL Encryption Symmetric Key Because Symmetric Key password does not exist in the Config DB" We have not used a backup, just a normal setup. We don't as for now use HTTPS.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

Deepesh161 6,317 on at

Like (0)

Report
Copy link

Link copied!

dynamicsofdynamicscrm.wordpress.com/.../crm-2013-create-email-error-cannot-open-sql-encryption-symmetric-key-because-symmetric-key-password-does-not-exist-in-config-db

Was this reply helpful? Yes No
Hakan 4 on at

Like (0)

Report
Copy link

Link copied!

Hi, if I use data encryption isn't there any disadvantages to this?

Was this reply helpful? Yes No
Suggested answer

Deepesh161 6,317 on at

Like (0)

Report
Copy link

Link copied!

Microsoft Dynamics CRM uses standard Microsoft SQL Server cell level encryption for a set of default entity attributes that contain sensitive information, such as user names and email passwords. This feature can help organizations meet FIPS 140-2 compliance.

For Microsoft Dynamics CRM Online and Microsoft Dynamics CRM (on-premises), all new and upgraded organizations use data encryption by default. Data encryption can’t be turned off.

See this: technet.microsoft.com/.../dn531199.aspx

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (0)

Report
Copy link

Link copied!

Hi Hakan,

check below link..

dynamicscrmgirl.wordpress.com/.../crm-2013-crm-and-sql-encryption

community.dynamics.com/.../118551.aspx

Hope above links will useful to resolve your issue.

Was this reply helpful? Yes No
Suggested answer

Hakan 4 on at

Like (0)

Report
Copy link

Link copied!

Hi all, I was a bit lucky because we could login using HTTPS, which meant that I could see and change key plus we had two instances of CRM. So I just had to copy the key from test to production and it alla worked. //Håkan

Was this reply helpful? Yes No
Prashnat Verma 287 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am also facing this error in the event log, actually I am not able to connect to Plugin registration Tool

I don't know what is the issue its throwing below error & I am using admin credentials.

Inner Exception Level 1 :
Source : System
Method : GetResponse
Date : 7/24/2018
Time : 9:42:06 AM
Error : Unable to connect to the remote server
Stack Trace : at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Description.MetadataExchangeClient.MetadataLocationRetriever.DownloadMetadata(TimeoutHelper timeoutHelper)
at System.ServiceModel.Description.MetadataExchangeClient.MetadataRetriever.Retrieve(TimeoutHelper timeoutHelper)
======================================================================================================================
Inner Exception Level 2 :
Source : System
Method : DoConnect
Date : 7/24/2018
Time : 9:42:06 AM
Error : A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 23.101.195.69:443
Stack Trace : at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
======================================================================================================================

Thanks

Prashant Verma

Was this reply helpful? Yes No