HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is replication possible on two different domains?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
replicationdomainsdifferentpossibletwo

Problem

I am implementing a database replication between different geograhical locations where each one is on a different domain. After going through all the process, when I start the agent it runs and stops.

When I look at the details it shows:

Error messages:
The process could not connect to Subscriber 'Mydomain\myusername'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20084)

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Source: MSSQLServer, Error number: 18452)

Solution

Replication across non-trusted domains or workgroups can be done using Windows Authentication by configuring pass-through authentication.

Create a local Windows account on both the Publisher and Subscriber that has the same username and password. Use this account for the replication agent process account and have the connections to the publisher, distributor, and/or subscriber impersonate this account. Ensure the account has the permissions required in Replication Agent Security Model.

This approach is covered in the section Use Windows Authentication to Set Up Replication Between Two Computers Running SQL Server in Non-Trusted Domains in HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet.

Context

StackExchange Database Administrators Q#52662, answer score: 6

Revisions (0)

No revisions yet.