SQL Server Encryption Certificate With Or Without Password
I run a client-server application and I am setting up a SQL Server 2008 R2 database with encryption. I am wondering if someone can give me the plus and minus of creating a certificate with a password versus creating one where the master key is used.
CREATE CERTIFICATE MY_Cert ENCRYPTION BY PASSWORD = 'MyPassword' WITH SUBJECT = 'MySubject';
versus
CREATE CERTIFICATE MY_Cert ENCRYPTION WITH SUBJECT = 'MySubject';
What is the consensus up and down side when encrypting and decrypting?
CREATE CERTIFICATE MY_Cert ENCRYPTION BY PASSWORD = 'MyPassword' WITH SUBJECT = 'MySubject';
versus
CREATE CERTIFICATE MY_Cert ENCRYPTION WITH SUBJECT = 'MySubject';
What is the consensus up and down side when encrypting and decrypting?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER