Replication Log Reader Agent Error "The principal dbo does not exist" 複寫記錄讀取器代理程式出現主體dbo不存在

  • Article

Replication Log Reader Agent Error "The principal dbo does not exist"

設定SQL Server Replication複寫時，Log Reader Agent複寫記錄讀取器代理程式出現以下錯誤

Error: 錯誤訊息

Error messages:

  • The process could not execute 'sp_replcmds' on 'SQLPublisher'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
    Get help: https://help/MSSQL_REPL20011
  • 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. (Source: MSSQLServer, Error number: 15517)
    Get help: https://help/15517
  • The process could not execute 'sp_replcmds' on 'SQLPublisher'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
    Get help: https://help/MSSQL_REPL22037

Cause: 原因

Publication database's owner does not exist

發行資料庫沒有設定擁有者

PS.通常發生在，當發行資料庫是從備份檔還原，而資料庫的建立者無法在還原的資料庫找到對應時，還原後就會是空白

Resolution: 解決方法

發行資料庫設定擁有者

1.right click on the database that you want to change the owner and go to “Properties” menu.
2.In the properties window, go to menu “Select a page -> Files”. Search or type the new owner.

Replication Log Reader Agent back to normal 恢復正常