Sharing MASTER KEY ENCRYPTION DB?

• pro-731305

  Say Hey Kid

  Points: 709

  More actions

  May 1, 2008 at 6:44 am

  #185909

  We have been using the following SQL Encryption on one database table in SQLExpress2005. Originally our application would only use the installed db server to run our db. Now we're considering allowing users to install our database on thier own SQL servers if they don't want to download and use SQLExpress2005..

  Q. Will our 'MASTER KEY ENCRYPTION', CERTIFICATE or SYMMETRIC KEY corrupt the users existing databases or db server?

  Q. How will installing our db on their db server effect master user name and password?

  [Sample Encryption]

  CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'secretpassword;

  CREATE CERTIFICATE MyCert WITH SUBJECT = 'MyDatabaseAccess', EXPIRY_DATE = '12/31/9999' ;

  CREATE SYMMETRIC KEY MySymKey WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE MyCert ;

  Zone:

  MS SQL Server