How to connect to SQL Server via proxy ?

[dong]

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:

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?

public static string sConnectionString = ??? // via proxy ???

[techgnome]

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

[dong]

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.