sql server replication: errors trying to setup merge replication -- sql server replication

errors trying to setup merge replication

Darin
8/30/2007 11:36:47 AM

sql server replication:

i have setup merge replication many many times, but I am receiving
errors on this machine. It crahsed, and we had to restore the data, so
now i am trying to setup merge again.

WHen I use EM (SQL 2000 on Windows 2003 server), I receive at the
configuring distributor step:

Error 15110: the proposed new database owner is already a user in the
database.
'distribution' is not configured as a distribution database.
etc

What database is it trying to set the owner for, and what owner is it
trying to use. I don't understand as I have never seen this before.

Help!!!

Darin

Re: errors trying to setup merge replication

Hilary Cotter
9/2/2007 12:00:00 AM

Can you do the following for me?

if exists(select *from sysdatabases where category=16)
print 'Distributor Exists'

If you get a message saying the distributor exists you need to drop it and
start again. If you do not try the following:

sp_adddistributiondb 'distribution1'

GO

sp_adddistpublisher @publisher=@@servername,
@distribution_db='distribution1'

Then go back and try to recreate your publication.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]