SQL Server 2005 Encryption options

• amackay_1

  Ten Centuries

  Points: 1240

  More actions

  March 25, 2007 at 8:57 am

  #172591

  Hi, I'm working on a project where we want to ensure that information in the system cannot be easily linked back to the user that it is associated to in case there was ever a security breach of the database itself.   I haven't used encryption within SQL Server before so I'm wondering if anyone has any suggestions on the best way to go about implementing something like this.  Should I be trying to encrypt the entire user table?  We don't necessarily need to hide that information, just the linkage to the details tables.  Any help would be appreciated.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 25, 2007 at 3:36 pm

  #696791

  Check the following links which give you good info...

  Improving Data Security by Using SQL Server 2005

  http://www.microsoft.com/technet/itshowcase/content/sqldatsec.mspx

  http://www.sql-server-performance.com/da_encryption_2005_1.asp

  http://www.sql-server-performance.com/da_encryption_2005_2.asp

  http://blogs.msdn.com/yukondoit/archive/2005/11/24/496521.aspx

   

  MohammedU
  Microsoft SQL Server MVP