any help would be greatly appreciated....
We have two servers,
one local SQLBI server running Windows OS.
One external Ubuntu server running SQL....
The sqlbi server needs to speak with the SQL server over SSH so it can create reports from the sql data.
There is an odbc link from the SQLBI server to the Ubunutu server which works...im a little confused - am i right in thinking currently the server is open to the world and its just fowarding on requests to the IP?
I think I need to create SSH port forwarding? and then reference localhost on the SQLBi server - how do I set this up?
thanks in advance