I normally connect to a SQL server from a C# or VB app using a connection string such as:
ersist Security Info=False;Initial Catalog=DBName;User ID=john;password=1234
This does not work when there is a proxy at the client side that blocks access through to the Internet.
All solutions I have found suggest that the client side IT staff open the proxy firewall for the required ports. In practice, people are often reluctant to open additional ports on the firewall. It is possible to go through the firewall using an HTTP tunnel, however I cannot get this to work to open a SQL connection. There are other methods available, for example Proxifier ( www.proxifier.com
) does this. Does anyone know how to do this in code, as I would prefer to avoid clients having to install an additional application on their machines.