Home Forums SQL Server 2005 SS2K5 Replication Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server RE: Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

  • April 25, 2013 at 1:56 pm

    #1610117

    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'