I've got a setup that I'm looking at where the publisher has a domain user account that runs the SQL Agent and all the subscribers are off domain and run SQL Agent under the local system account.
I have 2x identical servers that subscribe (Pull) to the above publisher - 1x successfully and 1x unsuccessfully. Error message is that it can't gain access to the network share to read the snapshot. If I change both Agents to run under a local user account both subscribe ok.
Can someone explain to me what the local system account can do and what it can't. I read somewhere that if you set up replication so that your login 'emulates' the Agent, it ca be set up with the local system account ? Is this so. Any help on this will be appreciated.