PHP PDO connects to MS SQLServer Express using SSL

Question

I have a remote MS-SQL Express 2012 server configured for use with SSL. I have all the certificates I need. But how can I create a PDO connection to this server using SSL? I found many articles for PDO with MySQL using SSL, but none of them for MS-SQL using PDO and SSL.

Answer 1

(Microsoft OS only) To connect securely, add "encrypt = true" to the connection string. Valuable blog on this topic .

Also Note:

Make sure you use:

• Microsoft Drivers

Make sure you are not using:

• Outdated
• Invalid driver

Drivers are here: Microsoft provided drivers .