sql server replication: Error 14058: The subscription already exists -- sql server replication

Re: Error 14058: The subscription already exists

Siu
3/31/2005 7:55:02 AM

Hi Hilary,
thanks for your answer, but your code still gives the message that the
subscription doesn't exist... I'm also sure that I've written correctly all
the parameter, namely the publisher name, publisher db and the publication
name.

Do you think that there is another problem?

[quoted text, click to view]

Re: Error 14058: The subscription already exists

Hilary Cotter
3/31/2005 10:42:12 AM

get your publication name and issue the following command in your
subscription database:

sp_droppullsubscription @publisher = 'publisher' , @publisher_db =
'publisher_db' ,[ @publication = 'publication'

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Re: Error 14058: The subscription already exists

Siu
3/31/2005 10:59:01 PM

Hi Hilary,
now I solved the problem: I had to delete the pull subscription manually
from the Publisher database.

I have another question: when I started the syncronitation, I got the
following error:

"The process could not connect to Disctributor 'MYDISTRIBUTOR'. Login failed
for user'

How can I discover which USER NAME failed the login?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.