Lesson Learned #13: SQL Server instance in use does not support column encryption
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.