如何从SQL Server获取加密数据？ [英] How do I get encrypted data from SQL Server?

问题描述

我在SQL Server中创建了一个测试数据库，并且我已经加密了一些字段来测试Access和SQL Server之间的加密连接。只是查看表格，加密字段中没有数据。甚至没有加密的mumbo jumbo数据。所以我的问题是我无法将加密数据导入Access以解密它。我花了最近几天在网上搜索，但我找不到任何东西。

I have created a test database in SQL Server and I have encrypted a few fields to test the connection between Access and SQL Server with encryption. Just viewing the table, there is no data in the encrypted fields. Not even encrypted mumbo jumbo data. So my problem is that I can''t get the encrypted data into Access in order to decrypt it. I have spent the last few days searching online, but I haven''t been able to find anything.

推荐答案

你是如何加密字段的？

我想这将是一个重要的细节:)我不完全确定正确的技术术语，所以如果我不清楚，这是我遵循的链接： SQL Server 2005数据库加密步骤一步一步。我创建了一个主密钥和一个证书。然后我创建了一个对称密钥（使用3DES，因为在XP上无法使用AES，这是我的测试笔记本电脑正在运行的）。然后我运行了一个UPDATE查询来将现有字段加密到一个新字段。


我希望这会有所帮助。

I guess that would be an important detail :) I''m not exactly sure the correct technical terms, so if I''m unclear, here is the link that I followed to do it: SQL Server 2005 Database encryption step by step. I created a master key and a certificate. I then created a symmetric key (using 3DES as AES isn''t available on XP, which is what my test laptop is running). I then ran an UPDATE query to encrypt the existing field into a new field.

I hope this helps.

老实说，我已经没有使用SQL服务器的这一部分。

我发现了这个：加密SQL Server 2012数据列


这看起来也很有趣;但是，我还没有完成阅读： SQL Server 2008企业版SQL Server 2008中的数据库加密


最后这篇文章与V2003相关
SQL Server 2008：通过SQL传递查询加密/解密数据


因此，您可能最终要么必须创建存储过程SQL Server用于在前端和后端之间推送加密数据，或者您需要创建一个基本上发送原始的passthru查询。 SQL绕过Jet / ACE数据库引擎的服务器。


[Z：{编辑：发现另一篇文章读得相当不错}]
SQL SERVER - SQL Server加密简介（...）

Honestly, I''ve not used this part of the SQL server.
I''ve found this: Encrypt a Column of Data SQL Server 2012

This also looks interesting; however, I''ve not finished reading thru it yet: Database Encryption in SQL Server 2008 Enterprise Edition SQL Server 2008

Finally theres this article as related to V2003
SQL Server 2008: Encrypt/Decrypt data through SQL Pass-Through Query

So it appears that you may end up either haveing to create a stored procedure on the SQL Server to push the encypted data between the front end and back ends or you will need to create a passthru query which basically sends the "raw" SQL to the server bypassing the Jet/ACE database engine.


[Z:{ Found another article that reads fairly well}]
SQL SERVER – Introduction to SQL Server Encryption(...)

这篇关于如何从SQL Server获取加密数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！