Last post Jun 14, 2017 03:24 AM by Eric Du
Jun 13, 2017 01:19 PM|sanjaykumar pushadapu|LINK
i execute below query in sql server 2016 i got Incorrect syntax near 'TRIPLE_DES' error and same query execute sql server 2012 comand execute successfully why i am getting issue in sql 2016?
CREATE SYMMETRIC KEY TestKey09 WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE Certificate1;
Jun 13, 2017 01:42 PM|kaushalparik27|LINK
I suggest you check out documentation @
Beginning with SQL Server 2016, all algorithms other than AES_128, AES_192, and AES_256 are deprecated. To use older algorithms (not recommended) you must set the database to database compatibility level 120 or lower.
Jun 14, 2017 03:24 AM|Eric Du|LINK
Hi sanjaykumar pushadapu,
According to your description of your issue, you say you could run it success in SQL Server 2012, but fail in the SQL Server 2016, I checked the document then found that because this
algorithm is deprecated in SQL Server 2016. For more details and solution, please check the following tutorial:
Incorrect syntax near 'TRIPLE_DES'. - SQL Server throws an error when try to use algorithms:
Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites;
therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from the Internet.