Link to home
Start Free TrialLog in
Avatar of cwruck
cwruck

asked on

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

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
DECRYPTION BY CERTIFICATE PasswordFieldCertificate

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.
ASKER CERTIFIED SOLUTION
Avatar of guvera
guvera
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cwruck
cwruck

ASKER

Reseach revealed the same links to solution.