Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

  • Hi Experts

    I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs are running still I can not drop the Publication. Please help

    Screen Short Attached of the problem

    Thanks

  • try this..

    sp_droppublication @publication='publicationName', @ignore_distributor = 1

  • Giving error

    Can not drop the Publication because at least one Subscription exists for this Publication.

    Drop all Subscription to the Publication before attempting to drop the Publication.

    Now I am getting this error . I never made any Subscription on my Subscription database.

  • Check under replication "Local Subscription"? Is there any?

  • No there is no Subscriptions there

  • Do you see anything under Local Publication then Publication and click on + of publication..If yes try the below mentioned command..

    USE master

    EXEC sp_removedbreplication @dbname='DBName'

    GO

    sp_dropsubscription @subscriber='SubscriptionName'-- If you find anything under +

    sp_droppublication 'PublicationName'

  • So I was able to remove the replication that command went fine, but there is no subscription & Publication is still there.

  • Glad it worked for you.

  • Thanks A lot

Viewing 9 posts - 1 through 8 (of 8 total)

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