Cannot find the symmetric key 'PasswordFieldSymmetricKey', because it does not exist or you do not have permission.

Posted on 2011-02-15
Medium Priority
Last Modified: 2012-05-11
I am setting up a test to allow columns of data to be encrypted using SQL Server 2005's native encryption.  I have been able to create the Database Master Key on my test database, the Certificate and the Symmetric Key.  Then I have attempted to open the Symmetric Key so I can use EncryptByKey to encrypt my data using the following commands in Management Studio logged in as a Windows Authenticated User:-

OPEN SYMMETRIC KEY PasswordFieldSymmetricKey

and I get the following error:

Msg 15151, Level 16, State 1, Line 1
Cannot find the symmetric key 'PasswordFieldSymmetricKey', because it does not exist or you do not have permission.
Question by:cwruck

Accepted Solution

guvera earned 1500 total points
ID: 34904056

Author Closing Comment

ID: 34939265
Reseach revealed the same links to solution.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
Businesses who process credit card payments have to adhere to PCI Compliance standards. Here’s why that’s important.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question