Copied to clipboard

Flag this post as spam?

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


  • Tom Bruce 122 posts 506 karma points
    Jul 11, 2018 @ 09:16
    Tom Bruce
    0

    Using SQL Always encrypted with Umbraco

    Hi everyone, I’m trying to use Microsoft Always Encryption to encrypt a couple of columns within the Umbraco database.

    When I encrypt one of the columns like the Email column within the cmsMember table, then I try to create a new member I receive an error;

    Operand type clash: nvarchar is incompatible with nvarchar(1000) encrypted with (encryptiontype = 'DETERMINISTIC',

    Any advice or pointers much appreciated ;)

  • WombleNumber1 6 posts 87 karma points
    Oct 17, 2024 @ 12:19
    WombleNumber1
    0

    Hi Tom,

    I realise this is a few years(!) later however did you ever manage to get SQL Always Encrypted working on the email field in cmsMember. I have literally the same requirement that I have posted about here, and am interested in whether or not you resolved this -

    https://our.umbraco.com/forum/using-umbraco-and-getting-started/114848-member-data-encryption

    Many thanks

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies