Page 1 of 1

How to connect through a proxy to an external SQL Server

Posted: Tue 07 Feb 2012 08:58
by brace
How to setup MS Connection so that it connects to an external server thorugh a proxy?

One customer can connect to the internet only through a proxy and he needs to connect to a server located at a particular external IP and port.

How to achieve this with TMSConnection?

Posted: Tue 07 Feb 2012 10:02
by AndreyZ
Hello,

To use non-standard port for connection, you should specify this port in the TMSConnection.Server property separated by a comma. Here is an example:

Code: Select all

MSConnection.Server := 'IP,Port';
To make possible connecting to SQL Server for your customer that can connect to the internet only through a proxy server, your customer has to set up the correct proxy network settings. These settings depend on particular used proxy server. This question can be solved only by network administrators. For more information, please refer to http://social.msdn.microsoft.com/Forums ... 4b4d207219

Posted: Tue 07 Feb 2012 10:12
by brace
Thanks a lot, I will convey this info to the network administrator.

The original request they did was "your app should support our company proxy"

Posted: Tue 07 Feb 2012 13:41
by AndreyZ
If any other questions come up, please contact us.