search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

Encrypted ssl/tsl connection #240

Closed Soni-Harriz closed 4 years ago

Soni-Harriz commented 4 years ago

Is tds_fdw support encrypted ssl/tsl connection to MS SQL Server on windows server ?

SudoerWithAnOpinion commented 4 years ago

tds_fdw uses FreeTDS to make the connections, as such options for FreeTDS deal with encryption.

Set encryption = require in your freetds.conf

[MSSQL]
 host = db.example.com
 port = 1433
 tds version = 7.3
 encryption = require
juliogonzalez commented 4 years ago

I think this qualifies for a doc PR.