–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 prevents a database administrator from accessing encrypted\u00a0data<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server cell level encryption<\/p>\n
Uses<\/b>:<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Used to store Email and Password when working with CRM and Microsoft Exchange<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yammer Integration<\/p>\n
Limitations<\/b>:<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 data encryption is not active in Microsoft Dynamics CRM 2013 on-premises by default but users who have the system administrator security role can activate data encryption<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 After data encryption is activated, it cannot be turn off but you can change the encryption key if required.<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Encryption cannot be applied on the custom fields. Currently it is only available on the out of the box password fields.<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Auditing cannot be enabled on encrypted fields<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Encrypted fields cannot be customized<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Encrypted fields cannot be indexed<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 When doing a retrieve of an encrypted field\u2019s value, a null is returned<\/p>\n
–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SSL is required to use messages<\/p>\n
To activate data encryption or change the encryption key you need to navigate to the Settings\u00a0->\u00a0Data Management\u00a0->\u00a0Data Encryption area. Please note that user having System Administrator role can only activate Data Encryption or change the Data Encryption Key.<\/p>\n
1)\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/span>IsDataEncryptionActiveRequest<\/b>: This request checks whether Data Encryption in Activated or not.<\/span><\/p>\n IsDataEncryptionActiveRequest request = new IsDataEncryptionActiveRequest();<\/p>\n IsDataEncryptionActiveResponse response = (IsDataEncryptionActiveResponse)service.Execute(request);<\/p>\n bool isDataEncryptionActive = response.IsActive;<\/p>\n 2)\u00a0\u00a0\u00a0\u00a0\u00a0 SetDataEncryptionKeyRequest<\/b>: This request helps to change the Data Encryption key. You just need to set the new encryption key in the Encryption Key property which will set the new encryption key.<\/p>\n SetDataEncryptionKeyRequest request = new SetDataEncryptionKeyRequest();<\/p>\n request.ChangeEncryptionKey = true;<\/p>\n request.EncryptionKey = “YOUR_ENCRYPTION_KEY”;<\/p>\n SetDataEncryptionKeyResponse response = (SetDataEncryptionKeyResponse)service.Execute(request);<\/p>\n 3)\u00a0\u00a0\u00a0\u00a0\u00a0 RetrieveDataEncryptionKeyRequest<\/b>: This function helps retrieve encrypted key available in the organization.<\/p>\n RetrieveDataEncryptionKeyRequest request = new RetrieveDataEncryptionKeyRequest();<\/p>\n RetrieveDataEncryptionKeyResponse response = (RetrieveDataEncryptionKeyResponse)service.Execute(request);<\/p>\n string encryptedKey = response.EncryptionKey;<\/p>\n Please note that, you must use SSL when you use these messages. When you execute these messages, a check will ensure that the user\u2019s client\/server connectivity is using the HTTPS protocol. If not, an exception is returned if the requests are submitted without using HTTPS.<\/p>\n Hope this article helps!<\/p>\n","protected":false},"excerpt":{"rendered":" Data Security is the prime aspect across the world. As we are storing all our data into the CRM, we need to keep our sensitive data in Encrypted format for the security reasons. Microsoft Dynamics CRM 2013 uses standard Microsoft SQL Server cell level encryption for a set of default entity attributes that contain sensitive\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[19,21,22,24],"tags":[396],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","tag-crm-2013-data-encryption-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=383"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/383\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"1\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2014\/03\/12-1024x569.png\")
<\/a><\/p>\n