系统登录用户“##MS_PolicyEventProcessingLogin##”被删除后，系统报错及处理

刘泽宇

由于某种原因，把系统登录用户“##MS_PolicyEventProcessingLogin##”删除后，在系统日志中发现大量如下提示，每5秒报一次错误。
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.’

解决方案：

分别进入msdb master模式,运行孤立用户修复：

EXEC sp_change_users_login ‘Report’
exec sp_change_users_login ‘AUTO_FIX’, ‘##MS_PolicyEventProcessingLogin##’
exec sp_change_users_login ‘UPDATE_ONE’, ‘##MS_PolicyEventProcessingLogin##’, ‘##MS_PolicyEventProcessingLogin##’