• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1270
  • 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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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