Local User Account and Replication

Hi - Suppose I wanted to do replication (merge) between two machines
that are not part of a domain. So I create the same Windows account on both
machines (with the same password) and start SQL Server services under those
accounts. Can I do all replication operations in this scenario?
In BOL it says "A domain user account is typically used because many
server-to-server activities can be performed only with a domain user
account" and one of the items is replication. Does that mean that
replication between two machines can only be done with domain accounts?
Thanks,
Maer
Your method should work. Your method is called pass through authentication,
or pass thru authentication.
You do not need to be in the same domain for this to work. Check out this kb
article for more info.
http://support.microsoft.com/default...b;en-us;321822
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Maer" <maer@.auditleverage.com> wrote in message
news:ewpJXdL0EHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi - Suppose I wanted to do replication (merge) between two machines
> that are not part of a domain. So I create the same Windows account on
both
> machines (with the same password) and start SQL Server services under
those
> accounts. Can I do all replication operations in this scenario?
> In BOL it says "A domain user account is typically used because many
> server-to-server activities can be performed only with a domain user
> account" and one of the items is replication. Does that mean that
> replication between two machines can only be done with domain accounts?
>
> Thanks,
> Maer
>