MS SQL Always Encrypted problem

,
1

Has anyone connected to MS SQL Always Encrypted database successfully ?

I am trying to connect to an MS SQL Always Encrypted database but I keep getting errors when inserting into an encrypted column:

The error I get is:
(S0002/206) Operand type clash: nvarchar is incompatible with nvarchar(4000) 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 = ‘***’)

I have the setting in my JDBC adapter: Column Encryption Setting=enabled

Anyone done this successfully ?

2

Hi @oliola76 ,

Had not connected earlier with MS SQL Always Encrypted database

But some time ago had come across a Database URL (JDBC Connection) with below parameters. Not sure if it was for MS SQL Always Encrypted database

encrypt=true;EncryptionMethod=SSL;ValidateServerCertificate=false;CryptoProtocolVersion=TLSv1.2

3

Hello and thank you for your reply.

I have the following parameters in my jdbc connection:
encrypt=true;trustServerCertificate=true; Column Encryption Setting=enabled;

I tried adding the parameters you mentioned but it did not work.

I have a feeling that the problem is somehow related to the encryption keys and webMethods not using them correctly (or using them at all), but I can’t be sure.