473,836 Members | 1,292 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do I get encrypted data from SQL Server?

Seth Schrock
2,965 Recognized Expert Specialist
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.
Mar 18 '13
13 9689
zmbd
5,501 Recognized Expert Moderator Expert
Seth:
Just in case you can move to SQLS2008: SQL Server 2008 Transparent Data Encryption getting started

Notice the comments/feedback: Scroll down... there is a question wherein the poster queries how to prevent users from seeing the plain data. Obviously missing the point that with TDE the data is (as mshmyob points out and so does the author) is only encrypted on disk. The DBA/Developer has to ensure that user access is setup correctly AND if a particular data field should not be accessible to everyone that the field is held in a data table that is 1:1 with the related table and is restricted by user/group AND/OR has implemented the column/field level encryption.

You might find this worth a watch too:
MSDN Blogs > Microsoft SQL Server Tips & Tricks > Transparent Data Encryption (TDE)
Mar 19 '13 #11
Seth Schrock
2,965 Recognized Expert Specialist
SQL Server 2005 is what we already have, so I was just using it. Moving to SQL Server 2012 has been discussed, but my job is to use what is provided, not make suggestions to buy new software. We have several other commercial databases running on the SQL Server and those take precedence over my databases.

Anyway, I did get the data to be unencrypted in the query. However it doesn't allow me to edit it or add new records. Does this mean that I would have to use UPDATE and APPEND queries to edit and add records?
Mar 19 '13 #12
zmbd
5,501 Recognized Expert Moderator Expert
Something of a pain with this... woefully, I haven't used the encrypted field/cell in SQLS so other than the links I've provided you, and the fact that you will have to use the pass thru queries to handle the encrypted information, sadly, I'll not be of much more help.
Hopefully Rabbit, NeoPa or one of the others will be able to provide more help.
Mar 19 '13 #13
Seth Schrock
2,965 Recognized Expert Specialist
I got it to work. What I ended up doing is to have the form based on a regular query. This allows me to add and edit records like normal. I then use unbound controls for the fields that I have encrypted. In the form's OnCurrent event, I use the DLookup function to get the values out of my Passthrough query for the current record. In each control's AfterUpdate event, I have it do an UPDATE passthrough query to set the new values in the table. Not the cleanest method probably, but it does work.
Apr 7 '13 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2868
by: Bruno | last post by:
Hi, Does anybody have any experience with Oracle Data Server (the Progress product)? I would love to exchange experiences and findings :-) Thanks, Bruno
0
1309
by: rparimi | last post by:
Hi, I have encrypted data stored in a table on a DB2 database. The encryption algorithm used to store data in the table is not important. Using a perl script and the DBI module, I was able to read the values stored in the column into an array. However, I do not know what transformation needs to be applied to this data (with pack or unpack for e.g) so I can use this variable for other tasks. When I run a select on the table from a db2...
5
2268
by: Nico | last post by:
My database have 20 tables and many users. I wish to store encrypted data in 3 tables and have only 3 users have access to them, walking into tables or using forms. Can someone point me a direct help or something to read? Tnx Nico
4
4587
by: Burke Atilla | last post by:
While encrypting data with DES through CryptoStream makes encrypted data bigger than original string. if we have 8 byte key and 8 byte of data then the mode is ECB. output encrypted data is 16 bytes long. first 8 bytes is out encrypted key but last 8 byte unknown. and while decrypting if we couldn't supply this 8 bytes we couldnt decrypt data. and get exception "Bad Data" What is this 8 bytes and how can i supply this data if i have only the...
3
4479
by: Todd Gruben | last post by:
I am trying to send some encrypted data from a php application to be decoded in a .Net application. Both apps encode/decode a given string but generate different encrypted results. Anyone have any idea? Code to follow: php====> <?php // Designate string to be encrypted $string = "This is a test";
6
1662
by: Microsoft | last post by:
Im trying to do a new app where i can store most of my passwords, basically another "Password Keeper" style tool.... Question about this is what is the best way to store the data, as a plain XML or MDB is totally insecure im wondering what other choices i do have and how do i can implement them.. Forgot to mention that im using VB.net 2005... Thanks
0
2189
by: smart.bug | last post by:
hi, i have SQLserver properly running on my machine, when i open a project in VB.Net and add a SQLConnection object, while setting its connection string (when i click on combo box to choose data server) it gives this error " error enumerating data server. enumerator reports 'Unexpected error' " i need help on this very urjent please. thanx WaC
9
2648
by: Suresh | last post by:
Hi All I have one column which has data type of varchar only. in this column i want to store some secured data (I want to store this data by encrpting using db2 encryption function).But along with this encrypted data this column contains normal data also.. But in DB2 while storing encrypted data column should be defined FOR BIT DATA. In my case how should I go as my column contains both encrypted and
1
2375
by: diSangro | last post by:
I need to transfer data from one machine to another , both have HP UX B.10.20 with same usr settings. Data to be transferred are used by Unify data server r.6.1 , installed on both these machines. In other words I have to copy one DB from the first machine to the second one . My idea is to copy two data files from the 1st machine to the 2nd : ...../bin/file.db -> this the application database file and
14
6851
by: wassssup | last post by:
hi guys..im new to datagridview and im wondering is there a way to convert an encrypted data in access and show it in a datagridview? im using C# and microsoft access normally this is how to show data in datagridview: OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""); OleDbCommand command = conn.CreateCommand(); string strSQL = "SELECT * FROM Employee"; ...
0
9666
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10836
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10585
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7786
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6976
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5645
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4447
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4009
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3108
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.