Post reply

Connect to a SQL Server through a proxy

  • March 30, 2022 at 8:59 am

    #4008083

    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

  • March 31, 2022 at 9:10 am

    #4008733

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

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

  • March 31, 2022 at 9:25 am

    #4008736

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

  • April 1, 2022 at 3:31 pm

    #4009391

    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)

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

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