Always on encryption with SQL Server 2016

rails-sqlserver / tiny_tds

TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.

Other

606 stars 189 forks source link

Always on encryption with SQL Server 2016 #404

Open YvesR opened 6 years ago

YvesR commented 6 years ago

Hello Ken,

I just run into this question: Does tiny_tds support Always on encryption?

See this link https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine.

I did not try, just want to know if pointless to try or give it a try. Reason is new coming law (EU-DSGVO) which raise the pressure to make encryption by design.

Thanks for info! Yves

metaskills commented 6 years ago

Great question. I have no idea but I would assume if they did make this change at the protocol layer, it would be behind some 7.4 flag in TDS similar to active directory https://github.com/rails-sqlserver/tiny_tds/issues/221

Are you able to test this? Also, the FreeTDS list might be a good place to check too since they are the source of all our powers.

YvesR commented 6 years ago

OK, I will take care of this and build a test environment and update you as soon I have any results. Or I update this threads if I need help :).