PHP on IIS7 with (PDO) MS-SQL support

Question

I'm running an IIS 7 windows server and a relevant part of my phpinfo's configure command currently reports this:

cscript /nologo configure.js ...... "--without-mssql" "--without-pdo-mssql" "--without-pi3web" ...... "--with-mcrypt=static"

What do I need to do to my server so that I can see the with-mssql above as opposed to seeing without-mssql?

I was once told to recompile PHP. That's where the buck stopped. Cause this PHP came with IIS install so we never needed to compile PHP before. Re-compiling... is that a command line thing?

There is no need to re-compile PHP. Just download a different version. — Brad
@brad, how do i make sure that the new version support with mssql. I thought, recompiling php gives the developer a chance the configure the php settings at the dos prompt. — Average Joe
@halfer, it's 5.3. We got no apps running on it. One idea to get the mysqli and mssql support it to reinstall. I found this link on micirosft site. microsoft.com/web/gallery/install.aspx?appid=PHP53 Shall I go ahead and install it over the existing version? Will it give me the chance to specify which extensions I want and I don't? — Average Joe
I've no idea if it will ask. But I should think you could tweak this in the php.ini if it doesn't. — halfer

Salman A Salman A · Accepted Answer · 2012-03-21T07:57:39

Microsoft SQL Server support and extensions are not shipped with PHP anymore. To connect PHP with SQL Server you need Microsoft Drivers for PHP for SQL Server:

The Microsoft Drivers for PHP for SQL Server is a PHP 5 extension that provides data access to SQL Server 2005 and later versions including SQL Azure.

The download page for drivers lists four versions to choose from. Consult the System Requirements page in order to determine which version you need. You must install the correct driver for your Operating System+SQL Server+PHP version combination.

You will also need one of these depending on which driver you choose (these must be installed separately):

SQL Server Native Client
Microsoft ODBC Driver 11 for SQL Server

The installer simply extracts the files in the specified location. You must the files to PHP extensions directory. The files are PHP extensions. The file names indicate:

nts/ts -- should be used with non thread safe/thread safe version of PHP
54/55/56... -- should be used with PHP version 5.4, 5.5, 5.6, ...
sqlsrv/pdo_sqlsrv -- provides procedural interface/PDO interface

Enable the extensions in php.ini file making sure that thread safetyness and PHP versions match.

Check phpinfo to see if extensions are loaded. Test sqlsrv_connect("servername") and new PDO("sqlsrv:server=servername") to make sure the extensions are working.

PHP on IIS7 with (PDO) MS-SQL support

2 Answers