none
SQLQueryNotificationService-GUID running on queue databasename.dbo.sqlqueryNotificationService-GUID output the followoing, 'Can not execute as teh database principal because "dbo" does not exits, This type of Principal cannot be impersonated, or you do

    Question

  • I have gone through many threads which advocate the above problem is may be due to insufficient privliges OR a falsy setup of broker service.

    I have checked the articles which present solution i.e
    http://rusanu.com/2006/06/17/the-mysterious-notification/

    AND

    http://rusanu.com/2007/11/10/when-it-rains-it-pours/

    these are nice article to find the solution but in my case these are not helpfull as i have done what is listed in these articles but the problem remains the same:)

    i am frequently observing the following error in my windows Application log

    The activated proc [dbo].[SqlQueryNotificationStoredProcedure-f27ecb39-bbaf-4ef7-b9bf-5aa301511d64] running on queue Database.dbo.SqlQueryNotificationService-f27ecb39-bbaf-4ef7-b9bf-5aa301511d64 output the following:  'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'

    i have checked the queues and service and none is available with the name [dbo].[SqlQueryNotificationStoredProcedure-f27ecb39-bbaf-4ef7-b9bf-5aa301511d64], Also no stored procedure is available with this name in the convern database!

    Can someone please explain!

    1:  How to stop these errors as these are bloating the applicaiton log with event iID 9724
    2:  How to reslove the problem :)
    3:  Does SQLQueryNotification create problem for IIS as a whole?

    4: It Seems the notification brings the website to its knees why ?

    I realy appritiate if someone has any clue?

    Talib


    Talib Butt

    Monday, June 10, 2013 9:13 AM

All replies

  • read http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/a4a6361a-01b0-4ed5-b624-94073c5930b1
    Tuesday, June 11, 2013 2:33 AM