Unable to replicate from on premise SQL server into Azure SQL Server due to encryption error.

[desmondchew]

We are running ODBC 18 drivers for SQL Server.

The source endpoint is on premise SQL Server 2022 but running on compatibility mode 110. We can't change it yet.

The target endpoint is Azure SQL Server.

Failed to check if table dbo.AIFENDPOINTACTIONPOLICY has encrypted columns
mssql_ae_is_table_encrypted(...) failed in CREATE STATEMENT for '
select count(*)
from sys.columns c
inner join sys.column_encryption_keys k on c.column_encryption_key_id = k.column_encryption_key_id
inner join sys.tables t on c.object_id = t.object_id
where c.encryption_type IS NOT NULL and schema_name(t.schema_id) = N'dbo' and t.[name] = N'AIFENDPOINTACTIONPOLICY'
'
RetCode: SQL_ERROR SqlState: 42S02 NativeError: 208 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'sys.column_encryption_keys'. Line: 1 Column: -1

[Chanty4u]

Hi try this 

https://customerportal.qlik.com/article/Qlik-Replicate-Errors-Due-to-Unsupported-SQL-Server-Versions?

[desmondchew · Accepted solution]

We are running SQL 2014 Azure SQL Server at the target. This explains. Thank you.