June 16, 2006 at 6:18 am
How do you connect to an sql server (ado.net) from a client machine when the client machine is behind a proxy.
I was told that I need to use a username/password and connect through port 8080 but I do not know how to set up the connection.
Do I have to set up some sort of SOCKS connetion with the proxy and then connect to localhost on the local port for the socks connection (like when you tunnel a port using ssh)?
June 16, 2006 at 7:22 am
I think you can configure SQL Server to accept queries via IIS. I haven't done this before but have read about it on this site before.
SQL Server uses its own protocol which your web proxy will have no idea how to handle and nor should it. Thus to use this protocol you would need SOCKS, SSH tunnel or the like.
Alternatively, as you have partially suggested, you could set up SQL to accept queries via IIS. The query is specified as part of the URL's query string (the bit after the ?) and the results are returned via HTTP. I'm sure there's some info somewhere on SQL Server Central about this. There's also the SQLXML pack that you can download for this purpose - you can get it from the Microsoft site.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply