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 2005 Forums
 SQL Server Administration (2005)
 Encryption

Author  Topic 

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2010-11-01 : 11:02:22

Hi friends,

I get this error for encryption,

Msg 15581, Level 16, State 3, Procedure val_enc, Line 22
Please create a master key in the database or open the master key in the session before performing this operation.

So I created the master key in the databsae and opened a new session and executed the procedure I got the same error. Every time I open a new session, I need to create master key or open the master key to execute the procedure..
Is there a work around for this to execute the procedure without opening the master key in every session?

Thanks
   

- Advertisement -