Solved

Guide to Replication between 2 SQL Databases in Non Trusted Domains

Posted on 2007-11-20
9
1,204 Views
Last Modified: 2012-06-27
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
Comment
Question by:bobbybongo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 42

Expert Comment

by:Eugene Z
ID: 20321233
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
 

Author Comment

by:bobbybongo
ID: 20321376
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
 
LVL 42

Expert Comment

by:Eugene Z
ID: 20321433
yes- > if you open sql server port (check DMZ solution) - it is not secure way

0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:bobbybongo
ID: 20321483
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
 
LVL 42

Accepted Solution

by:
Eugene Z earned 250 total points
ID: 20321583
0
 

Author Comment

by:bobbybongo
ID: 20326354
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
 

Author Comment

by:bobbybongo
ID: 20326471
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to handle time out inside the stored procedure 10 27
Powershell help for creating accounts 283 56
SQL Server Resume 5 46
SQL Instance service gone? 5 39
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question