Security – Encrypting an ODBC connection

encryptionodbcSecuritysql server

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?

Best Answer

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