Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


  • We have a SQL Server 2008 R2 database sitting in a data centre
  • We would like to allow analysts to connect to the database and query the data using desktop based tools (e.g. Tableau) via ODBC. The desktop based tools do not necessarily support encryption.
  • We need the data and queries to be securely encrypted while in transit over the network

Is there a good / reliable way to achieve this - e.g. some kind of local ODBC proxy that can then communicate with the server over an encrypted connection?

share|improve this question

migrated from Aug 24 '11 at 1:24

This question came from our site for professional and enthusiast programmers.

up vote 4 down vote accepted

If you're using the SQL Server Native Client for ODBC, you should be able to configure it to do this for you.

share|improve this answer

Ive had good results in stunnel when i had to convert SMTP to SSMTP on devices that did not support SSMTP natively.

I dont know what encryption MSSQL Server supports but if its not SSL you can still use stunnel on the server to decrypt the messages and serve them to another port.

This is more inspiration then an real answer ^-^

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.