TDE Master Key issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

TDE Master Key issues

Author

Topic

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-09-21 : 10:52:47

Why do I get this error -
Please create a master key in the database or open the master key in the session before performing this operation.

I am executing this code:

USE MyUserDB;
GO
CREATE CERTIFICATE MyHighCert
    WITH SUBJECT = 'TDE';
GO

I am trying to create a certificate in MyUserDB.

Regards

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-09-21 : 20:18:28

Ok - I figured out my problem - I needed to create a database master key prior to creating a certificate in the user db:

USE myUserDB ;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword'
GO

This created the database master key in myUserDB. Encryption then follows using this key.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources