August 29, 2010 at 12:27 am
Got below message in SQL error log. This occured after i used db mail first time(created account, profile, stmp). The mail failed, maybe because port has not been opened. How to interpret this error? Also how to check whether db mail is enabled?
The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the following: 'Cannot execute as the database principal because the principal "##MS_PolicyEventProcessingLogin##" does not exist, this type of principal cannot be impersonated, or you do not have permission.'
August 29, 2010 at 4:35 am
You may find these discussions useful.
http://www.sqlservercentral.com/Forums/Topic941445-391-1.aspx#bm941974
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply