Disabling Distributor & Publishing Error

  • Dear,

    I am trying to disable my distributor and publisher in replication but I am getting the following error message.

    [

    TITLE: Microsoft.SqlServer.ConnectionInfo

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

    SQL Server could not disable publishing and distribution on 'SERVER1'.

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

    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)

    ]

    please help me to sort out the problem.

    Regards,

    Akbar

  • please check if there any db_owner for your database used in replication.

    if there is no change it to SA or any other active login

    use Yourdatabase

    go

    sp_changedbowner 'sa'

    -----------------------------------------------------------------------------
    संकेत कोकणे

  • sanket kokane (11/7/2012)


    please check if there any db_owner for your database used in replication.

    if there is no change it to SA or any other active login

    use Yourdatabase

    go

    sp_changedbowner 'sa'

    pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"

  • pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"

    Hi thats just a informational message ..

    I think link below will help you more

    http://support.microsoft.com/kb/913423/en-us

    -----------------------------------------------------------------------------
    संकेत कोकणे

  • Hi thats just a informational message ..

    I think link below will help you more

    http://support.microsoft.com/kb/913423/en-us

    I have gone through the above link. But I am using SQL Server 2008 R2. Will it work?

    Thank You.

  • its working fine for me in SQL serevr 2008 R2

    or else another option is

    ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

    GO

    -----------------------------------------------------------------------------
    संकेत कोकणे

  • Thank you, SSC Veteran for your co-operation.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply