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
    'distribution' is not configured as a distribution database.

    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.


    Darin, Aug 30, 2007
    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'


    sp_adddistpublisher @[email protected]@servername,

    Then go back and try to recreate your publication.

    -- - dedicated to mining blogs for business intelligence.

    Looking for a SQL Server replication book?

    Looking for a FAQ on Indexing Services/SQL FTS
    Hilary Cotter, Sep 2, 2007
    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.