Connect to a SQL Server through a proxy

  • Hello,

    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?


    thank you

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • i used th ewindows built-in proxy and it works great!

  • evald wrote:

    i used th ewindows built-in proxy and it works great!


    Thanks for posting the solution that you found for your own question.  It's going to help others, for sure.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply