none
SQLServer 2008 配置replication之後出現以下錯誤. RRS feed

  • 问题

  • 環境SqlServer 2008 企業版 SP1 +Windows 2003 企業版

    將sqlAgent服務的啟動帳號設置為本地的一個OS帳號,并給該帳號授予administrators組權限,并將該帳號加入到SqlServer的login中,賦予sysadmin權限 .

    發佈數據庫和訂閱數據庫的owner都是電腦名稱\administrator .

    可以配置好發佈與訂閱,但是後續根本就不能同步,檢查發現log reader執行不了
    報錯原因為:
    2011-04-01 07:25:53.468 The process could not execute 'sp_replcmds' on 'LH-CSDDB'.
    2011-04-01 07:25:53.468 Status: 0, code: 15517, text: '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.'.
    2011-04-01 07:25:53.468 Status: 0, code: 22037, text: 'The process could not execute 'sp_replcmds' on 'LH-CSDDB'.'.

    而且後續disable distribution and publication的時候報錯:
    TITLE: Microsoft.SqlServer.ConnectionInfo
    ------------------------------

    SQL Server could not disable publishing and distribution on 'LH-CSDDB'.

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    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.
    Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)

    For help, click: http://go.microsoft.com/fwlink?P ... 17&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    請問到底要怎麼才能disable掉分發與發佈.

    另外當將發佈數據庫和訂閱數據庫的owner修改為sa的時候,replication就可以正常運行.

    難道配置replication的時候 必須設置數據庫的所有者是sa嗎?

    If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
    2011年4月1日 12:17

答案

全部回复