SqlDependency Permission issue

I am getting the following error while staring the sqldependency

Cannot find the specified user 'owner'. Cannot find the queue 'SqlQueryNotificationService-dfb11997-c69e-4e3b-a640-29cdf4c3e9fa', because it does not exist or you do not have permission. Invalid object name 'SqlQueryNotificationService-dfb11997-c69e-4e3b-a640-29cdf4c3e9fa'.

I already gave the following permissions. Not sure what other permissions to give to the sql role/user. Appreciate your time and help

GRANT CREATE PROCEDURE to [SqlUser] 
GRANT CREATE QUEUE to [SqlUser]
GRANT CREATE SERVICE to [SqlUser]
GRANT REFERENCES on 
CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]
 to [SqlUser] 
GRANT VIEW DEFINITION TO [SqlUser] 
GRANT SELECT to [SqlUser] 
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [SqlUser] 
GRANT RECEIVE ON QueryNotificationErrorsQueue TO [SqlUser]
GRANT ALTER ON SCHEMA::dbo TO [SqlUser]
GRANT CONTROL ON SCHEMA::[dbo] TO [SqlUser]; 
GRANT IMPERSONATE ON USER::DBO TO [SqlUser];
ALTER USER [sqluser] WITH DEFAULT_SCHEMA=[SqlUser]
GO

  • Edited by G vinod 11 hours 10 minutes ago
July 10th, 2015 3:59pm

I think a more interesting question is where this user 'owner' comes from. That sounds like a mishap.

Free Windows Admin Tool Kit Click here and download it now
July 10th, 2015 6:01pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics