• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1387
  • Last Modified:

Guide to Replication between 2 SQL Databases in Non Trusted Domains

I am trying to set up transactional replication between 2 servers that can only see each other via IP address and are in different domains.

I am trying to use FTP to do this but I am having trouble finding any information on how to do this?

Does anyone have a guide on how to do this as I am a novice on this subject

Thanks
0
bobbybongo
Asked:
bobbybongo
  • 4
  • 3
1 Solution
 
Eugene ZCommented:
check:

HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet
http://support.microsoft.com/kb/321822
--
Configuring Microsoft Internet Security and Acceleration Server for Microsoft SQL Server 2000 Replication over the Internet
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/proxy.mspx

--
************************************************
for sql server 2005 (not in your case. is it?) it is :

http://www.sql-server-performance.com/articles/dba/replication_across_internet_p1.aspx
0
 
bobbybongoAuthor Commented:
Thanks but this seems to suggest that the initial snapshot will only be transferred via FTP?

The most important part is that the transactional replication via FTP - is this possible?
0
 
Eugene ZCommented:
yes- > if you open sql server port (check DMZ solution) - it is not secure way

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bobbybongoAuthor Commented:
We are trying to get round the security issue of having the port open? I take it this is not possible then and I will require to use another solution?
0
 
bobbybongoAuthor Commented:
Thanks for your help so far.

I'm in the process of reading that article. Would I be better moving to 2005 [which is a possibility] i.e. would this scenario be easier to implement/fix by using SQL 2005?

0
 
bobbybongoAuthor Commented:
I have read the above article.

We already have this architecture set up. The question we are trying to address is how to FTP the transactional replication from the internal network via FTP to the DMZ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now