TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
L G
NA
1
1.2k
Using Master Keys and Certificates
Feb 5 2014 6:20 PM
How do you use certificates to encrypt data from a table on database and decrypt it on another database? Does it involve master keys?
I was able to encrypt and decrypt on the same database using certificates. However when I tried to create the same certificate on a different database using a backup file I got the error message -
Please create a master key in the database or open the master key in the session before performing this operation
Do I need to create a master key on the source database and then use it on the target database as well? I'm using SQL Server 2008.
Any help is much appreciated. Thanks!
Reply
Answers (
0
)
how to connect with data base
What is joins & its type