How do I fix this SQL Server always encrypted error?

• bob.olender

  SSC Veteran

  Points: 266

  More actions

  January 29, 2021 at 12:50 pm

  #3838710

  I had to change a column originally encrypted as Randomized. I used the wizard and changed it to Deterministic. I saw the error below when I tried to update a row in my asp.net application. So, I changed it to plain text. Verified I could see the text in SSMS (took a back up of the records). Then encrypted it again as Deterministic.

  Rebuilt my index

  What I'm seeing in my asp.net application, is that sometimes I can edit the record. Sometimes it saves the record. Other times it show the error below. But after the error, if I edit again and resave there are no more errors.

  This is the error.

  Operand type clash: nvarchar(7) encrypted with (encryption_type = 'RANDOMIZED', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'CCCAPX1') is incompatible with nvarchar(max) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'CCCAPX1')

  Any ideas of how I can fix this.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 30, 2021 at 1:10 pm

  #3839058

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• bob.olender

  SSC Veteran

  Points: 266

  More actions

  February 1, 2021 at 3:05 pm

  #3839678

  As an update, I'm still seeing this sporadically.  The records are being updated via an asp.net web page --  a simple update statement.  Its been working fine for years prior to the change in encryption type.