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 ?

score 0 · Answer 1 · answered Aug 07 '14 at 18:47

0

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.

answered Aug 07 '14 at 18:47

mlibby

6,567
1
32
41

Yes! In that case what should I do? – Aug 08 '14 at 19:36
Either log into SQL Manager as `sa` to do this work or create a separate DB user account to grant these to. – mlibby Aug 09 '14 at 18:56
Thanks you all!! that was the help I was needing. – Aug 15 '14 at 15:05
I'm still facing the same issue. What should i do? – Jitendra Pancholi May 16 '16 at 09:55

score 0 · Answer 2 · answered Nov 25 '15 at 07:54

0

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO YourUserName;

Use your login username insted of YourName

answered Nov 25 '15 at 07:54

suraj mahajan

832
1
12
21

SignalR and Query Notifications in sql

2 Answers2