Post reply

Encrypt SQL server 2014 instance

  • June 8, 2015 at 11:44 am

    #298799

    Hello All,

    I've 2 instances running on SQL server 2014 standard edition. I've to encrypt 1 instance completely. Can this be achieved in SQL server 2014? If not, how can I encrypt the database in SQL server 2014. Any help/input is greatly appreciated.

    Thanks

  • June 8, 2015 at 12:18 pm

    #1803774

    When you say "encryption" , do you mean Transparent Data Encryption?

    or row level encryption, which requires each protected column to have data type changes, and encryption and decryption routines to handle all the protected columns?

    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!

  • June 8, 2015 at 1:00 pm

    #1803792

    I meant row level encryption. Sorry about the confusion. Any thoughs how can I achieve that? Thanks

  • June 8, 2015 at 3:08 pm

    #1803834

    First identify what needs encrypting. You'd never encrypt every column, just columns containing sensitive data.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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