SQL Server Performance

Replication without a domain

Discussion in 'SQL Server 2005 Replication' started by SGriffiths, Sep 7, 2007.

  1. SGriffiths New Member

    I have two SQL 2000 server both in the same 'workgroup', but not in a domain.
    I've read there are different options, but would like some advice on which is the better route to go.
    thanks
    Susan
    SGriffiths, Sep 7, 2007
    #2

  2. ghemant Moderator

    ghemant, Sep 9, 2007
    #3

  3. satya Moderator

    In this case you will be running with local system account, to achieve the replication you can use the subscriptions to create a sql account on the subscriber which is in the dbo_role on the subcriber in the subscription database. Use the same account name & password when you are creating your subscription in the connection to the subcriber dialog box, in the section connect to your subscriber.
    satya, Sep 10, 2007
    #4

Share This Page