Interview Question in SQL Server 2005
Interview Question :: 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!
Loading ...