How do I find and/or grant permissions to a SQL encryption key for a specific user?
Posted on 2014-03-20
First, I am working with a database I did not setup let alone encrypt. I'm just in charge of creating some stored procs and getting them accessible to a SQL account user.
I can run the stored procs within SSMS but when I try to reach them through a web service I have created to serve up the data I get this error...
"Cannot find the symmetric key 'SKEY_DataEncryption', because it does not exist or you do not have permission."
How do I find the key? (Do I even need to find it...?)
How do I grant the necessary permissions to my web service designated user account within SQL Server 2008?