Results 1 to 3 of 3

Thread: How to connect to SQL Server via proxy ?

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2008
    Posts
    460

    How to connect to SQL Server via proxy ?

    Suppose I have 2 network layers: network layer A and network layer C, network layer A is the internal network layer without using the internet, network layer C uses the internet, in network layer C I use management software sales with SQL Server connection over the Internet, with following chain connection:
    Code:
    public static string sConnectionString = @ "Server = IP WAN, Port 1433; Database = MyData; User Id = sa; password = xxx";
    The question is, I am at network layer A, intranet layer, how do I want to use sales management software to connect SQL Server via proxy? If I use a proxy connection, how should I fix it?
    Code:
    public static string sConnectionString = ??? // via proxy ???

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    33,140

    Re: How to connect to SQL Server via proxy ?

    The IP should be the IP of the proxy server, along with the appropriate port designated on the proxy server for SQL Server. I've got an interesting situation where my own machine is my proxy, so all my connections are to localhost... the vpn tunnel then does port forwarding to the AWS serves as needed. It's all based on the server name/IP address and the port

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2008
    Posts
    460

    Re: How to connect to SQL Server via proxy ?

    Your case presentation is not the same as mine. the server is not using a proxy, the server is WAN IP, port 1433, user = sa, pass = xxx. The question I ask from the client that connects to the server uses a proxy because the client has 2 layers: the network layer A is the non-internet internal network layer, the network layer C is the network layer that has internet, if I run the business software In network layer C the program runs normally, in contrast, I run in network layer A the program can't run so I need a proxy to run the program.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width