PHP PDO connect to MS SQLServer Express using SSL

Question

I have a remote MS-SQL Express 2012 server that is set up for use with SSL. I have all the certs I need. But how can I create a PDO connection to this server using SSL? I have found plenty of articles for PDO with MySQL using SSL, but none for MS-SQL using PDO and SSL.

Unfortunately not. We set up a VPN and use a non-SSL connection. — Sander Marechal
– Sander Marechal, Commented Sep 10, 2015 at 8:20
did you try like this : $c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=bddtest", "Utilisateur@12345abcde", "MotDePasse"); ? — Mimouni
– Mimouni, Commented Oct 15, 2015 at 13:32

Kyle Wiering · Accepted Answer · 2015-10-24 19:40:58Z

0

(Microsoft OS Only) In order to connect securely, append 'encrypt=true' to the connection string. A valuable blog on the topic.

Also Of Note:

Make sure you are using:

Microsoft Drivers

Make sure you aren't using:

The drivers are located here: Microsoft provided drivers.

edited Oct 24, 2015 at 19:40

answered Oct 24, 2015 at 19:34

Kyle Wiering

4745 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sander Marechal Over a year ago

Unfortunately that driver only works on Windows. My web servers all run Linux.

Kyle Wiering Over a year ago

You might be able to use FreeTDS. I am unable to test and verify - but that is the only way I'm aware of in Linux. (it might even use SSL for domain auth connections by default).

Collectives™ on Stack Overflow

PHP PDO connect to MS SQLServer Express using SSL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related