 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Service Broker / July 2006SqlCacheDependency Notification Issue
Hi, I have problem with sqldependency getting the following exception. 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 user 'owner', because it does not exist or you do not have permission. Cannot find the queue 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Cannot find the service 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Invalid object name 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda'. i have performed all steps instructed in the following links. http://blogs.msdn.com/dataaccess/archive/2005/09/27/474447.aspx http://forums.asp.net/2/1179033/ShowThread.aspx but still have the same problem. plz help as soon. Thanks in Advance, Mudassar Senior Sofware Engineer Hi Mudassar, Did you create your user for this with the sp_adduser command or with CREATE USER or SQL Server Management Studio? sp_adduser works differently with respect to creating a default schema, and I believe that's what this page (http://forums.asp.net/2/1179033/ShowThread.aspx) used. Right below the description is the same Exception Details reported by Luis Abreu. I believe this was the resolution. http://www.sqlskills.com/blogs/bobb/Default.aspx#a5bf0e1ac-0faf-41be-af35-b24d64 e0d45a Cheers, Bob Beauchemin http://www.sqlskills.com/blogs/bobb Hi, I have problem with sqldependency getting the following exception. 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 user 'owner', because it does not exist or you do not have permission. Cannot find the queue 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Cannot find the service 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Invalid object name 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda'. i have performed all steps instructed in the following links. http://blogs.msdn.com/dataaccess/archive/2005/09/27/474447.aspx http://forums.asp.net/2/1179033/ShowThread.aspx but still have the same problem. plz help as soon. Thanks in Advance, Mudassar Senior Sofware Engineer Sorry bad link. I'd meant to put in a link to the posting "About Schemas and Query Notifications" on June 29. Here it is: http://www.sqlskills.com/blogs/bobb/PermaLink.aspx?guid=5bf0e1ac-0faf-41be-af35- b24d64e0d45a#a5bf0e1ac-0faf-41be-af35-b24d64e0d45a. The latest posting on the blog "Pre-provisioning and SqlDependency" is on the same topic but unrelated to your problem. Cheers, Bob Hi Mudassar, Did you create your user for this with the sp_adduser command or with CREATE USER or SQL Server Management Studio? sp_adduser works differently with respect to creating a default schema, and I believe that's what this page (http://forums.asp.net/2/1179033/ShowThread.aspx) used. Right below the description is the same Exception Details reported by Luis Abreu. I believe this was the resolution. http://www.sqlskills.com/blogs/bobb/Default.aspx#a5bf0e1ac-0faf-41be-af35-b24d64 e0d45a Cheers, Bob Beauchemin http://www.sqlskills.com/blogs/bobb "Mudassar" <mudasir_2good@hotmail.com> wrote in message news:OWfRyLJnGHA.1208@TK2MSFTNGP04.phx.gbl... Hi, I have problem with sqldependency getting the following exception. 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 user 'owner', because it does not exist or you do not have permission. Cannot find the queue 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Cannot find the service 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda', because it does not exist or you do not have permission. Invalid object name 'SqlQueryNotificationService-be04f527-8845-497c-80ab-d288356c2fda'. i have performed all steps instructed in the following links. http://blogs.msdn.com/dataaccess/archive/2005/09/27/474447.aspx http://forums.asp.net/2/1179033/ShowThread.aspx but still have the same problem. plz help as soon. Thanks in Advance, Mudassar Senior Sofware Engineer |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.