SSH tunnel to MSSQL
Posted: Fri May 12, 2006 4:03 pm
I had to access an MSSQL database remotely and I wanted to use SSH tunneling for that.
Legend:
[ME] ... The network I am in.
[THEM] ... There's the SQL server.
Here's how I've done it:
1) At [THEM] I've started PuTTY and entered a remote port tunnel to their MSSQL server:
...and opened the connection to our [ME] SSH server.
Hint: If accessing a forwarded port doesn't work, check if the ssh-user you're connecting with is allowed to open the requested port(s).
Here's PuTTY's log in such a case:
2) On my side [ME], I started the "cliconfg" utility: "C:\WINNT\SYSTEM32\CLICONFG.EXE"
- Under "GENERAL", add/enable the protocol "TCP/IP".
- Under "ALIAS" add a new alias "FARSIDE" with server name "x.x.x.x", Protocol "TCP/IP".
(where "x.x.x.x" is the IP of my local SSH server)
3) In order to connect to the remote database, use "FARSIDE" as servername. The system resolves this to the SSH server's IP.
Legend:
[ME] ... The network I am in.
[THEM] ... There's the SQL server.
Here's how I've done it:
1) At [THEM] I've started PuTTY and entered a remote port tunnel to their MSSQL server:
Code: Select all
4L1433 127.0.0.1:1433Hint: If accessing a forwarded port doesn't work, check if the ssh-user you're connecting with is allowed to open the requested port(s).
Here's PuTTY's log in such a case:
Event Log: Forwarded connection refused by server: Administratively prohibited [open failed]
2) On my side [ME], I started the "cliconfg" utility: "C:\WINNT\SYSTEM32\CLICONFG.EXE"
- Under "GENERAL", add/enable the protocol "TCP/IP".
- Under "ALIAS" add a new alias "FARSIDE" with server name "x.x.x.x", Protocol "TCP/IP".
(where "x.x.x.x" is the IP of my local SSH server)
3) In order to connect to the remote database, use "FARSIDE" as servername. The system resolves this to the SSH server's IP.