Getting the encrypted column "xxx" using CommandBehavior = SequentialAccess is not supported

Question

I installed the Azure SQL database and enabled Always Encrypted.

One of the columns (column 3) is equal varchar(Max).

When I query a database from SSMS without using "column encryption setting=enabled", I see that all columns have binary data.

When I query a database from SSMS using "column encryption setting=enabled", I get an error message as shown below:

An error occurred while executing the package. Error message: Getting the encrypted column "column3" with CommandBehavior = SequentialAccess is not supported.

Here's what my table definition looks like:

CREATE TABLE [dbo].[mytable](
    [column1] [varchar](2000) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
    [column2] [datetime] ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
    [column3] [varchar](max) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL
)

If I remove the encryption in column3, everything will be fine, and I will see the decrypted values.

Did I miss something?

Answer 1

Always Encrypted.

SQL Server Azure SQL DB VARCHAR (MAX) " = " SSMS, SSMS Sequential Access varchar (MAX). SSMS , ( , ). , , Always Encrypted . , -, HMAC , HMAC .

varchar (max) " = " ADO.Net( SequentialAccess).

Answer 2

​​ SSMS 16.3, 2016 . varchar (max) LOB.