Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Situation:

  • 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 stackoverflow.com Aug 24 '11 at 1:24

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

add comment

2 Answers 2

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
add comment

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

http://www.stunnel.org/

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
add comment

Your Answer

 
discard

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.