Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sharing MASTER KEY ENCRYPTION DB? Expand / Collapse
Author
Message
Posted Thursday, May 01, 2008 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 2:57 PM
Points: 9, Visits: 21
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
Post #493525
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse