SQL 2000 - Unable to drop remote Server

I am trying to drop a remote server which was previously used for replication. When I try and delete it I receive the following error:

Error 20583 Cannot drop server 'server' because it is used as a subscriber in replication

I have check in EM under replication and there are no items displayed. Is there anywhere else this needs to be removed from.
LVL 5
NetstoreAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
CetusMODConnect With a Mentor Commented:
PAQed with points refunded (350)

CetusMOD
Community Support Moderator
0
 
chhapia_chintakCommented:
Try following:

sp_serveroption 'servername', 'sub', 'off'

sp_dropserver 'servername, 'droplogins'

where 'servername' is the SQL Server you want to drop. This will remove the
entry in the sysservers table for this SQL Server and it will no longer be
a subscriber.

Hope this helps
0
 
NetstoreAuthor Commented:
Tried that and on the sp_dropserver command I get the following

Cannot drop server 'RemoteServer' because it is used as a Subscriber to remote Publisher 'LocalServer' in replication.

Where LocalServer is the server I am running the command on to remove the remoteserver
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
NetstoreAuthor Commented:
The above error is 20584 so differs slightly from the first error....
0
 
NetstoreAuthor Commented:
I've worked it out, I needed to Disable the replication to fully un-install it. For fututr reference :

Ent Manager -> Replication Folder -> Right Click -> Disable Publishing and Distribution and then select yes to disable the functionality and go through the wizard. I have now deleted my remote server....get in !!!

Please close call
0
 
dcoerverCommented:
This solution worked for me!
Thanks!
0
All Courses

From novice to tech pro — start learning today.