I have a SQL server database that only has an internal IP address and the server does not face the outside; it is not NATed to a public IP address for security reasons. I have a client that wants to connect to a view on the database through an ODBC connection on his end.
I tried setting up a linked server with a SQL database that does face the outside, but not sure if I could create some sort of a tunnel that way.
All that I need is for this client to be able to connect via an ODBC connection to a view on an Internal database. Is there a possible way to do this?