4

Is SQL Server's new encryption "at rest and in motion" feature available in the Express version of SQL Server 2016?

Nikhil Vithlani - Microsoft
  • 797
  • 5
  • 13
stovroz
  • 6,835
  • 2
  • 48
  • 59
  • 1
    It's hard to give a definitive answer before it actually RTMs, but for now the answer is much closer to "no". You can download a RC build and check for yourself. – dean Apr 26 '16 at 13:58
  • 1
    Based on http://download.microsoft.com/download/8/A/2/8A2BC8C5-BBA0-4A9C-90BC-AC957D3454D9/SQL_Server_2016_Editions_datasheet.pdf it would appear that it's only an enterprise edition feature. – Mark G May 09 '16 at 21:09
  • Always encrypted is now supported even in [LocalDB](https://sqlperformance.com/2016/11/sql-server-2016/big-deal-sp1) – Panagiotis Kanavos Dec 19 '16 at 14:09

2 Answers2

11

The Always Encrypted feature is not available in express edition. It is available in SQL Server Enterprise and Developer editions only.

Edit: With 2016 SP1, Always Encrypted feature is now available with all versions of SQL Servers. More on what's new in SP1 here (Edit courtsey-@Ender2050)

More details on feature comparison for different editions of SQL Server 2016 - https://www.microsoft.com/en-us/sql-server/sql-server-editions

Yogi
  • 9,174
  • 2
  • 46
  • 61
7

Always Encrypted is supported in all versions of SQL Server 2016 SP1, according to the link posted above by Yogi. This must have changed recently. 2016-Q4.

https://www.microsoft.com/en-us/sql-server/sql-server-editions

enter image description here enter image description here

Ender2050
  • 6,912
  • 12
  • 51
  • 55