How to perform Replication within different domains?
Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet.
Also the simplest way to do this is to create relevant number of local administrator accounts with the same name and password. Use this account as the local SQL Server agent account on all computers. This is called PassThrough authentication.
If you want to use SQL Server authenication, impersonate the sa or relevant privileged account, make sure all of your snapshot folders are to a location like \\serverName\ShareName and the the everyone group\account has read access permission underlying the ShareName directory.
It is recommended that you use a SQL Server agent account that has access on the remote domains though, or use passthrough authentication.
