Note that there are some explanatory texts on larger screens.

plurals
  1. POCan I do SQL Server 2005 merge replication through an SSH tunnel?
    primarykey
    data
    text
    <p>Our usage case is a database responsible for accounts, sessions, licenses, etc. — it needs to be polled upon client startup, so high reliability is crucial. As such, we'd like to replicate across different servers in physically separate networks, just in case an entire datacenter happens to go down. I have successfully set up a push subscription to another server in the same network, so this generally works. It's the connection to servers <em>outside</em> the network that I need to get working now.</p> <p>Replication doesn't work directly across networks. Microsoft <a href="http://msdn.microsoft.com/en-us/library/ms151319(SQL.90).aspx" rel="nofollow noreferrer">suggests either a VPN or web replication</a>. The latter strikes me as inefficient (and they do say "Note: Web synchronization is designed for synchronizing data with portable computers, handheld devices, and other clients. Web synchronization is not intended for high-volume server-to-server applications.")</p> <p>The former, a VPN, would work, but I still consider it a needlessly complex solution (not to mention the added potential for security issues) to continuously run a VPN connection. <strong>I'd much rather just run an SSH tunnel.</strong> Yet, I can't find any article that explains how to do this and isn't about MySQL.</p> <p>I've got an SSH server set up on the subscriber, and have used PuTTY to establish a tunnel from <code>&lt;publisher&gt;:1434</code> to <code>&lt;subscriber&gt;:1433</code>. I cannot, however, get SQL Server Management Studio to connect this way (I'm not sure it supports the <code>:</code> port syntax). I've also set up an alias on <code>&lt;publisher&gt;</code>'s SQL Server Configuration Manager, with <code>@@servername</code> of <code>&lt;subscriber&gt;</code>, pointing to <code>localhost:1434</code>. Connecting to that doesn't appear to work either.</p> <p>I used the push subscription option, so I figure the publisher needs to connect to the subscriber, not the other way 'round.</p> <p>Both servers use the default instance, and run SQL Server 2005 SP 2 on Windows Server 2003 SP 2. The SSH server on the subscriber is freeSSHd 1.2.1.</p> <p>Is this possible at all? Is there another way I can leverage SSH to pretend the machine exists within the same network? Or do I have to go with a VPN?</p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload