i have an application which connects to of course an SQL Server. The SQL is a shared service, thus i don't manage it but i have access to the db the app is using as owner. Now, these two machines(SQL and App server) are on the cloud and i can have access only on the app server with RDP and i can install stuff there. I need a way to reach the SQL Server from an internet IP passing through the app server which is the only one i have control. The idea basically to use some kind of proxy to be installed on the app server.
Now the question is, is doable? consider also that i need read only access on the tables and views of the db. Which software to use? Any feedback on this kind of configuration? What could go wrong?