Connect PHP to SQL Server with Always on Encryption


I run web applications with PHP, SQLSRV and MS SQL (2014 web).

With the forthcoming GDRP legislation I am considering encrypting my sql databases. Please can anyone advise if ugrading to SQL Server 2016 (web) and using AlwaysOn Encryption is a possibility. I would like to not have to recode all my queries, but could easily change my connection strings.

I am also looking at row-level security as my database tables are shared across multiple clients, with an an identifiying "clientid" on each record to distiguish which record belongs to which client. Can anyone advise if this is possible and practical.

Thank you
Who is Participating?
DBAduck - Ben MillerPrincipal ConsultantCommented:
I believe you are referring to Always Encrypted and not AlwaysOn encrypted.

With your PHP site you will need to ensure that you have the right version of either ODBC or the PHP driver that supports always encrypted. This is possible from what we know in your post. You will have to validate the specifics with driver versions and how your code has to change.  The only thing in your code that has to change is the connection properties you set in PHP.

Row Level security does exist in 2016 Web so you are good there.
rwlloyd71Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.