MSSQL_CERTIFICATE_STORE Operation is not supported on this platform

Question

I'm working with a .NET Core 3.1 application (C#) and facing the error message like this when I sent requests to a docker container insides ubuntu server:

"Failed to decrypt a column encryption key using key store provider: 'MSSQL_CERTIFICATE_STORE'. The last 10 bytes of the encrypted column encryption key are: 'xx-xx-xx-xx-xx-xx-xx-xx-xx-xx'.\nOperation is not supported on this platform."

According to this link (https://learn.microsoft.com/en-us/sql/connect/odbc/using-always-encrypted-with-the-odbc-driver?view=sql-server-ver15), it seems like Linux doesn't contain MSSQL_CERTIFICATE_STORE and force me to use Azure Key Vault Store.

My question is 'Is it possible to integrate MSSQL_CERTIFICATE_STORE and Linux environment without using the Azure Key Vault Store?'

score 1 · Accepted Answer · answered May 26 '20 at 07:50

1

If you want to still use Windows Certificate Store in Linux environment, we need to configure it on Windows machine, export the certificate and install it on the Linux machine. For more details, please refer to the article

Meanwhile, for Linux client application, we can use Azure Key Vault Store with ODBC driver. Besides, if you do not want to use Azure Key Vault Store, you can use Custom store providers with ODBC driver. For more details, please refer to the document and the document

answered May 26 '20 at 07:50

Jim Xu

21,610
2
19
39

Thanks ! I will try the custom one because the Azure isn't fit for my working environment (in many ways..) – Firstfrozen Jun 05 '20 at 08:26
Did you succeed? – Ali.Rashidi Nov 02 '22 at 13:03
@Jim Xu https://stackoverflow.com/questions/74252524/using-sql-server-always-encrypted-in-asp-net-core-app-that-is-deployed-to-docker – Ali.Rashidi Nov 03 '22 at 06:14

MSSQL_CERTIFICATE_STORE Operation is not supported on this platform

1 Answers1