ODBC Connection to a Remote DB through an SSH Tunnel?

I have a remote SQL 2005 Express database on a server and have a remote client connecting to the server with SSH. I have the SSH setup right (I think) and I am able to telnet to port 5000 on 127.0.0.1, which is being forwarded to 10.10.10.20 port 1344. When I try to do an ODBC connection to the SQL Server it is not working so I don't know what I am doing wrong. When I try to do the ODBC, I am putting in the SQL instance name (SQLS\SQLExpress) and typing in the correct username and password and it is saying "SQL Server not found". On the SQL Server I have TCP/IP and Named Pipes turned on, as well as remote and local connections enabled. What am I doing wrong!

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    SSH Tunnels are cool... but Hamachi VPN is easier. Try it!

Still have questions? Get your answers by asking now.