Lesson Learned #13: SQL Server instance in use does not support column encryption
Published Mar 13 2019 06:17 PM 3,142 Views
First published on MSDN on Dec 30, 2016
Today, I worked in a support case that our customer is using the following components:

When they connect to local application to their Azure SQL Database, everything works fine. After their code is deployed to Azure App Service they got the error: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server instance in use does not support column encryption .

We found the issue that is explained at: https://github.com/Microsoft/mssql-jdbc/issues/65 and we suggest the following workaround: https://github.com/Microsoft/mssql-jdbc/pull/76

We hope to have a final fix soon. Our Product Team reported that they already tested the fix which one can find in Dev branch https://github.com/Microsoft/mssql-jdbc/tree/dev You can use this dev branch code in TEST / STAGE environments.
Version history
Last update:
‎Mar 13 2019 06:17 PM
Updated by: