SignalR and Query Notifications in sql

Question

I'm new in signalr, and reading and surfing the net I found this incredible (I think) tutorial http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency. But I have a problem, when I run the statement GRANT SUBSCRIBE QUERY NOTIFICATIONS TO "Domain\ASPNET" replacing Domain\ASPNET with my Windows credentials, the SQL management threw this error:

Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

There is something wrong in my procedure? There is any other way to implement this push from the database ?

Answer 1

Looking at the error message you posted, I'd guess you are logged into SQL Manager using the same credentials you are attempting to GRANT to.

Answer 2

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO YourUserName;

Use your login username insted of YourName