Post reply

Encryption

  • August 9, 2012 at 8:32 am

    #264947

    Please point me to links where I can decide on a solution to encrypt PII column using SQL Server 2008?

    Thank you.

  • August 9, 2012 at 8:38 am

    #1523832

    Encryption was introduced in 2005, but the methods are still teh same, even for 2012;

    I relaly liked this article enough to bookmark it: and keep it and it's code in my snippets.

    http://www.databasejournal.com/features/mssql/article.php/3714031/SQL-Server-2005-Encryption-types.htm

    and another one that is very similar

    http://www.4guysfromrolla.com/articles/022807-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 9, 2012 at 9:54 am

    #1523911

    Thank you Lowell!

    I read the article. I have a question what if the password for the certificate is misplaced OR could not retrieve the original password. How should one get back the encrypted data. If the password is lost forever then the data is lost too?

    Is there a way to retrieve the encrypted data back using Master Key or by other means?

  • August 9, 2012 at 9:58 am

    #1523915

    As Far As I Know, if you lost the passPhrase for creating the certificate, you would also lose the ability to decrypt anything that was encrypted with it.

    if someone were to delete the certificate, you can recreate it with the same passphrase and be able to recover encrypted columns;

    that would be very common where you copy a database to another server...you need to create the same certifiicate to get the data on the new server.

    RJ-476420 (8/9/2012)

    Thank you Lowell!

    I read the article. I have a question what if the password for the certificate is misplaced OR could not retrieve the original password. How should one get back the encrypted data. If the password is lost forever then the data is lost too?

    Is there a way to retrieve the encrypted data back using Master Key or by other means?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 9, 2012 at 10:05 am

    #1523923

    Ok. In that case is there a way to create certificates without Passphrase like third party certs installed on the OS, certs authorized by windows authentication, etc.,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply