I am beating my head trying to get this to work. I am using this article:
I am trying to enable ASP.Net and SQL Server 2008 SQL Caching Dependency in a test application. I am totally confused on what the user should be for the:
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO "TESTSERVER\ASPNET"
I created a user called "TestUser", that user has grant access where I ran all of these:
GRANT CREATE QUEUE TO "TestUser"
GRANT CREATE SERVICE TO "TestUser";
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO "TestUser";
GRANT RECEIVE ON QueryNotificationErrorsQue
ue TO "TestUser";
My code I am getting an error: "Unable to connect to the SQL database for cache dependency registration." on the line:
Any idea what I am suppose to do?