Database Master Key

• Davy_Davido

  SSC Enthusiast

  Points: 120

  More actions

  September 21, 2007 at 12:29 pm

  #121710

  Hi, this is my problem.

  I have a database that I'm moving back and forth between two SQL server 2005 on two different machines. And I have encrypted columns in some tables using native SQL server 2005 encryption. But the problem is that each time I move the data from one machine unto another I have to regenerate the database master key (without the FORCE option) else it's not able to decrypt my data.

  Is this by design or there is anything I'm doing wrong, try to go through the BO but nothing much.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 24, 2007 at 2:45 pm

  #735781

  This is a duplicate post found here http://www.sqlservercentral.com/Forums/Topic401281-146-1.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question