Always Encrypted Client Driver installation

Mark Sanchez 101 Reputation points
2021-08-17T15:03:58.123+00:00

We are doing research on SQL Server Always Encrypted. One question we have is in regards to the client driver. We would be using the .NET Framework Data Provider for SQL Server. Is this included as part of the .NET Framework 4.6 or would we need to install a separate driver package to all our clients to enable the client decryption as part of AE?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,868 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 102.2K Reputation points
    2021-08-17T21:22:55.43+00:00

    .NET Framework 4.6 should be good enough for plain Always Encrypted. If you plan to use Always Encrypted with Enclaves, you will need a newer version.

    SqlClient has been lifted out from .NET Framework, and is now Microsoft.Data.SqlClient, which is what you would use for the most recent features.

    0 comments No comments

  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-08-18T06:28:58.857+00:00

    Hi @Mark Sanchez ,

    You need to ensure .NET Framework version 4.6.1 or higher is installed on your development machine. You also need to ensure .NET Framework version 4.6 or higher is configured as the target .NET Framework version in your development environment.

    The level of support for Always Encrypted in particular versions of .NET Framework varies. Please, see the Always Encrypted API reference section below for details.

    Please refer to MS document Using Always Encrypted with the .NET Framework Data Provider for SQL Server.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments No comments