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?
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 ;
MS SQL Server