errors trying to setup merge replication

Discussion in 'microsoft.public.sqlserver.replication' started by Darin, Aug 30, 2007.

  1. Darin

    Darin Guest

    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
     
    Darin, Aug 30, 2007
    #1
    1. Advertisements

  2. 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 @[email protected]@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
     
    Hilary Cotter, Sep 2, 2007
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.