使用EncryptByPassPhrase解析SQL Server 2014中由sql server 2017加密的数据 [英] Decrypt data in SQL Server 2014 encrypted by sql server 2017 using EncryptByPassPhrase

问题描述

我正在尝试在SQL Server 2014中解密在Sql Server 2017中加密的数据。请帮助

解决方案

根据为加密选择的选项，您需要选择相应的解密选项来解密列数据。可用选项通过密钥，证书或密码加密

请参阅此处的详细信息

https://docs.microsoft.com/en-us/sql/relational-databases/security/加密/加密的层次结构？视图= SQL服务器-2017

I am trying to decrypt data encrypted in Sql Server 2017 in a SQL server 2014. Please Help

解决方案

Based on the option chosen for encryption, you need to choose corresponding decrypt option for decrypting the column data. The available options are encrypting by key, certificate or passphrase

see details here

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encryption-hierarchy?view=sql-server-2017

这篇关于使用EncryptByPassPhrase解析SQL Server 2014中由sql server 2017加密的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！