How to troubleshoot "Encryption not supported on the client OLE DB provider "SQLNCLI11" for linked server" error
It seems you are using always encrypted for some columns in the database. This is not supported or functional with linked servers (or other means of distributed queries), as documented here . Quote from that page:
&quot;The following features don't work on encrypted columns:
Transactional or merge replication
Distributed queries (linked servers, OPENROWSET(T-SQL), OPENDATASOURCE(T-SQL))&quot;
For Always Encryped (AE), the encryption/decryption of data is done by the client, the API on the client side. APIs that supports AE include ADO.NET, JDBC and ODBC. Linked Server uses OLEDB (the calling server is a client to the remote server), and OLEDB do not have the functionality to encrypt/decrypt for AE.