0

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?

2 Answers 2

4

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

2

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 ^-^

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .