Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
SQL- Encryption Database

I have taken backup from the live environment and trying to use it on the local box. The database in the live is encrypted with a key.

I have restored the database to localbox and cannot run any stored procedures as I have the following issue:

Please create a master key in the database or open the master key in the session before performing this operation.

Has anybody faced this issue, and how did you manage to solve? Could you provide the answer step by step?

I know the password for the encryption on the live DB.

share|improve this question

marked as duplicate by mrdenny Apr 14 '11 at 2:32

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

up vote 2 down vote accepted

Can you try:

open master key decryption by password = '<your password>'
alter master key add encryption by service master key
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.