Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jonathan Roberts 409 posts 1063 karma points
    Jul 18, 2017 @ 13:02
    Jonathan Roberts
    0

    Installing Umbraco onto 2016 with Encryption

    HI,

    We would like to install the new version of Umbraco using SQL 2016 and using the Encryption feature for all columns that are deemed sensitive.

    Is this possible? And if so how can we set this up?

    Thanks

    Jon

    Copy Link
  • Paul de Quant 403 posts 1521 karma points
    Jul 18, 2017 @ 15:12
    Paul de Quant
    1

    I've installed Umbraco on SQL Server 2016 and as a test I chose to encrypt the umbracoUser table and the following columns:

    • userName
    • userLogin
    • userPassword
    • userEmail

    SQL Server 2016 has encrypted these as expected but now I can't login to the system anymore - from what I've read all you need to add to your website is this - to your connections string:-

    Column Encryption Setting=enabled

    Can't figure out why this doesn't work.

    Has anyone else had luck with this.

    Cheers

    Paul

    Copy Link
  • Paul de Quant 403 posts 1521 karma points
    Jul 18, 2017 @ 15:13
    Paul de Quant
    0

    Currently getting this error in the Logs -

    2017-07-18 16:06:49,633 [P4016/D6/T31] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (e3602545). System.Data.SqlClient.SqlException (0x80131904): Operand type clash: nvarchar(125) encrypted with (encryptiontype = 'DETERMINISTIC', encryptionalgorithmname = 'AEADAES256CBCHMACSHA256', columnencryptionkeyname = 'CEKAuto1', columnencryptionkeydatabase_name = 'umbraco-cms') is incompatible with varchar

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft