Hamachi:Microsoft SQL Server Connection

From LogMeInWiki

Jump to: navigation, search

Overview

Hamachi can be used as connectivity method to your Microsoft SQL Server. This is useful if you have remote users that use a local application that is database driven in another location. Rather than opening up ports on your network firewall, you can use Hamachi to tunnel directly, and safely, to the database server.

Detail

First, the SQL server needs to be told that it has to listen for network TCP connections and on which interfaces to do so.

Launch the SQL Server Configuration Manager and go to Network Connections > Protocols.
image:sql_server_1.png

Double Click TCP/IP.

Enable TCP/IP as a connection method.
image:sql_server_2.png

Enable the server to listen on the Hamachi IP address.
image:sql_server_3.png

The server can now be connected to via the Hamachi interface. The last step is to ensure the clients can connect. This step is more a verification is the client is still in the default Hamachi configuration.

Go to Network Connections > Advanced > Advanced Settings and ensure Hamachi is the first adapter in the list.
image:sql_server_4.png

That should be all that's needed to allow SQL connections via Hamachi.

Notes

To connect to the server, make sure you use the Hamachi IP, not the host name, unless you either add a HOSTS file entry or run a DNS solution through the connection. IP mapping will also have a slight performance gain over hostname mapping to the server.

  • You CAN NOT use the "Block Vulnerable Microsoft Services" option in Preferences > Security > if you are running SQL on it's default port, as this feature blocks it.

Add to: del.icio.us | Digg | Slashdot

Personal tools