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.
  2. ghemant Moderator

  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.

Share This Page