2

On SQL Server 2008 R2, I execute this command:

GRANT REFERENCES ON ASYMMETRIC KEY ::CorpKey to XYZZYEXT;

I get this result:

Msg 15151, Level 16, State 1, Line 1
Cannot find the asymmetric key 'CorpKey', because it does not exist or you do not have permission.

I've checked a bunch of articles, including

Can't grant role permissions under sysadmin login

But I'm just not seeing the problem.

closed as off-topic by Paul White, Colin 't Hart, Michael Green, Marian, RolandoMySQLDBA Apr 21 '15 at 14:51

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, Colin 't Hart, Michael Green, Marian, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

3

This is not an ASYMMETRIC KEY, it is a SYMMETRIC KEY. Change

GRANT REFERENCES ON ASYMMETRIC KEY

to

GRANT REFERENCES ON SYMMETRIC KEY

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