Use LogMeIn Hamachi with Microsoft SQL Server
Hamachi can be used as connectivity method to your Microsoft SQL Server. This is useful if you have remote users using a database-driven local application that is in another location.
Rather than opening up ports on your network firewall, you can use LogMeIn Hamachi to tunnel directly, and safely, to the database server. The following steps are required for the SQL Server to accept connections on the LogMeIn Hamachi interface. These steps were written for SQL Server 2005.
Configure MS SQL Server for connectivity over Hamachi
- Launch the SQL Server Configuration Manager and go to .
- Double-click TCP/IP
- Set Enable to Yes
- Select IP Addresses
- Set Active and Enable to Yes for the LogMeIn Hamachi IP.
This is all that is required on a default install of LogMeIn Hamachi and MS SQL Server 2005 to enable connectivity to the server. You may also want to ensure that you can resolve the SQL Server by hostname, as some services MS SQL Server offers, such as replication, require it.