[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

I have a user that needs permissions to start System.Data.SqlClient.SqlDependency.Start

I Created the USER and i created a role SQLDependency
got it from here
http://www.keithelder.net/blog/archive/2009/01/20/sqldependency-and-sql-service-broker-permissions.aspx

And Granted SQLDependency Alter on schema dbo so i dont get the error "Cannot find the specified user 'owner'."

But still having this error

Cannot find the queue 'SqlQueryNotificationService-2c9dda3f-5403-4c2f-81de-7c6d6317a345', because it does not exist or you do not have permission.
Invalid object name 'SqlQueryNotificationService-2c9dda3f-5403-4c2f-81de-7c6d6317a345'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot find the specified user 'owner'.
Cannot find the queue 'SqlQueryNotificationService-2c9dda3f-5403-4c2f-81de-7c6d6317a345', because it does not exist or you do not have permission.
Invalid object name 'SqlQueryNotificationService-2c9dda3f-5403-4c2f-81de-7c6d6317a345'.




0
roland206
Asked:
roland206
1 Solution
 
JestersGrindCommented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now