all groups > sql server replication > april 2007 >
You're in the

sql server replication

group:

Urgent issue: Removing a remote server



Urgent issue: Removing a remote server PromisedOyster
4/3/2007 6:24:35 PM
sql server replication: Ref: SQL Server 2000 Standard Edition

I want to remove a remote server (DR) from one of my servers (PRODA)
so that I can add it as a linked server.

However, when I try to remove the remote server, I get the error:
There are still remote logins for the server 'DR'.

[quoted text, click to view]
and replication is NOT running on PRODA. (Note at one time replication
was once running)

On the DR server, replication is running as this gets replicated data
from other servers.

When I look at the publishers list on the DR server, the PRODA server
is in the list of potential publishers but it is not enabled. I would
be very reluctant to disable replication on the DR server as this is
used extensively.

The article below suggests that replication needs to be disabled from
PRODA, however it is already is.

http://msdn2.microsoft.com/en-us/library/aa274571(sql.80).aspx

However, for some reason DR, thinks that PRODA is still a potential
publisher?????


I hope this makes sense as I simply want to add DR as a remote server
from PRODA.
Re: Urgent issue: Removing a remote server PromisedOyster
4/3/2007 10:19:08 PM
On Apr 4, 11:24 am, "PromisedOyster" <PromisedOys...@hotmail.com>
[quoted text, click to view]
Problem resolved by running sp_dropserver, 'DR', 'droplogins'

AddThis Social Bookmark Button