1

To utilize Always Encrypted feature in SQL Server, impleting Azure Key Vault provider is the most convenient option. However, it has a dependency with the Azure cloud network.

Azure Key Vault cannot be used for on-premise intranet only deployments. When the application is running on Windows Server, any Windows comptibale provider like MSSQL_CERTIFICATE_STORE can be used. But if the application is running on Linux server, there is no provider available.

What is the recommend solution to use a key store provider for Always Encrypted SQL Server on Linux machines?

PC.
  • 6,870
  • 5
  • 36
  • 71

1 Answers1

0

One possible way is to use ODBC Driver 17 for always encrypted SQL Server running on Linux machine. You can download the driver from here.

This official document will help you to understand all the prerequisites and implementation steps.

Utkarsh Pal
  • 4,079
  • 1
  • 5
  • 14