Database connection through proxy

Question

I'm using entity framework 5.0 in my asp.net c# website project.

The database server is on a remote server, my developer machine is behind a HTTP proxy with LDAP authentication.

How can I configure my project to use specific proxy settings to establish the connection to my MSSQL server?

What kind of proxy is it? SOCKS5?

Joachim Isaksson
– Joachim Isaksson

2013-04-12 10:05:55 +00:00
Commented Apr 12, 2013 at 10:05 — Joachim Isaksson
– Joachim Isaksson, Commented Apr 12, 2013 at 10:05
I've updated my answer. It's HTTP.

Felix C
– Felix C

2013-04-12 10:08:21 +00:00
Commented Apr 12, 2013 at 10:08 — Felix C
– Felix C, Commented Apr 12, 2013 at 10:08

Joachim Isaksson · Accepted Answer · 2013-04-12 11:43:55Z

2

Since SQL Server does not use HTTP communication natively, it will not work with an HTTP proxy (unless the proxy allows passthrough in which case it's really disconnecting itself from acting as a proxy and this page may be of interest). Far form all HTTP proxies will allow this.

To expose data from the SQL server to your installation through an HTTP proxy, you may instead want to consider creating an OData service on the SQL server side, and use that for data access in your application. This will allow you to query the database over HTTP in a proxy friendly way.

answered Apr 12, 2013 at 11:43

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database connection through proxy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related