CODEWITHSUNDEEP
sql-serversshssh-tunnel
alisichkin
alisichkin

Reputation: 51

Connect to remote MS SQL Server using SSH tunnel

I need connect to remote MS SQL Server using SSH tunnel. I have installed on remote server freeSSHd, set up router, allow TCP connection through 22 port. I can connect to remote server using putty. When I setup tunnels in putty - L1433 RemoteServerIP: 1433

So, I execute Microsoft SQL Management Studio, and try to connect to localhost(127.0.0.1). But instead of connection to remote computer Studio connect to local SQL. I logging putty session – but no information about tunnelling.

I made putty setting on the basis of the following article: https://courses.cs.washington.edu/courses/cse444/11wi/resources/tunneling-instructions.html

What am I doing wrong?

Upvotes: 1

Views: 13791

Answers (1)

Ceredig
Ceredig

Reputation: 131

Is your local SQL server also listening on port 1433? (as you mentioned it connects to the local server)

If yes, then PuTTY will not be able to open port 1433 as the local side of your tunnel.

Use a different local port (-L) - one which is free on your system - when setting the tunnel up. And course, do specify this port when attempting to connect.

Upvotes: 2

Related Questions