Replication between Non-Trusted Domains

[aomara]

I wander if any one can tell me How to establish a replication (whatever it's type) between 2 servers who are in different domains .

The point is that those domains are non-trusted for each other means that any user in the first domain is not recognized in the second domain and vise versa.

As you know that the SQLSERVERAGENT must start with the same domain user in both servers, but as those domains dont have a trusted relation ship between each other, so you can't use the same user, where this is must in replication connections.

The Network Administrator refuse to establish trusted relation between the 2 domains due to security issues.

We have 128 k bit connection between those servers and both domains can ping each others IP's

 

[mrdenny]

You can use ftp for the file transfer. As you go through the wizzards to setup the replication you should be able to tell it that you want to use SQL Accounts instead of Windows accounts.

Using FTP for the file transfer will require that you setup IIS on one or both SQL Servers.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

BTW, IIS is a security risk when set up on a SQL Server.

I've never been able to get replication to work between two non-trusted domains. I had to do a similar thing a while back for a contract job I was on and ended up doing replication from the production server to a non-prod server (in the same domain) and then from there doing a log-shipping kind of thing to a drive mapped to the non-trusted domain, restoring the logs on the non-trusted domain so that it was in perpetual Read-Only restoring mode.

It was a little bit strange, but it worked and it kept the non-trusted domain people off of my production server.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"