locked
Issue in Deletion the Publisher in Transactional with updatable subscriptions Replication RRS feed

  • Question

  • HI All,

     I am unable to Delete the Publisher in Transactional Replication. it was give error message.


    Could not delete publication 'Test_001'.

    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 'Test_001'. (.Net SqlClient Data Provider)

    Help me how to delete the Publisher from replication

    Thanks,Prasad R.

    Friday, August 6, 2010 9:24 AM

Answers

  • Hi Phasad,

     

    According to the error message you provided, this issue is probably caused by that the user which you logged on to delete the publisher is not sa (sysadmin), or the user does not have sysadmin permission, or the owner of the publisher database is not sa.

     

    Based on my research, this issue also occurs when you restore or attach the publisher database from another instance of SQL Server and the owner of the publisher database is a domain user or a SQL Server authorization login.

     

    To work around this issue, please use sa account to connect to SQL Server, run the following script to change the owner of the publication database to sa, and then delete the publication again.

    USE master

    ALTER AUTHORIZATION ON DATABASE::[publicationdatabase] TO [sa];

    GO

     

    For more information, please see the following links:

    You cannot run a statement or a module that includes the EXECUTE AS clause after you restore a database in SQL Server 2005: http://support.microsoft.com/kb/913423/en-us

     

    Two similar threads:

    http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/a4a6361a-01b0-4ed5-b624-94073c5930b1

    http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/20801dbc-9a26-4f2d-9148-22d5a8a890ed

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu


    - MSFT
    • Marked as answer by SAAD's Wednesday, August 11, 2010 9:51 AM
    Monday, August 9, 2010 8:24 AM

All replies