An owner of a MS SQL db has allowed access to their db from an IP address of a remote machine I own. I can SSH into that machine and connect to the DB using:
ssh -i my.pem 22.214.171.124
sqlcmd -S xxxxx.database.windows.net -d MYDBNAME -U MYUSERNAME
Now I want to use a frontend GUI and connect to that database from my local machine. Is this possible? Do I need to install something on my remote machine?
(I tried using SSH Tunnel with DBeaver but get error "The TCP/IP connection to the host 127.0.0.1, port 11232 has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port." I'm not sure if "host" means my remote machine or the database host.)