KMP uses Microsoft's SQLSRV driver, which installs as a PHP extension, to connect to a MSSQL database. This guide explains how to install this driver on Windows 2008, Windows 2012 and Windows 7 with IIS7.
Supported PHP versions:
- PHP v5.3.6+
- PHP v5.4.*
- PHP v5.5.*
- PHP v5.6.*
Download the SQLSRV30.EXE file from the official Microsoft website.
Double click on the downloaded file. It is a self-extracting archive. It will ask you where to extract the files. Use a temporary target folder for this, you would need only one of the extracted files.
Check the upacked files. You can see a bunch of them, though you need only one file. We recommend to use one of the PHP versions listed above compiled with VC9 or VC11, x86 Non Thread Safe. It has to match the version of your PHP, e.g. for PHP v5.6 Non Thread Safe you would need this driver:
Copy the driver file to the PHP extensions directory. By default it is C:\PHP\ext. If you're not sure, check the "extension_dir" parameter in the php.ini file.
To load the sqlsrv dirver, add the following line to the php.ini (adjust the name if needed):
Also, you would need to install the following packages from Microsoft on the web server:
You would need to download the "vcredist_x86.exe" file from both pages, launch it and complete the installation.
Then restart the web server.
To determine whether the driver has been successfully loaded, run a script that calls phpinfo().
Search for "sqlsrv" on that page (use Ctrl-F shortcut in your browser). If sqlsrv driver is installed correctly, you should see something like this:
Microsoft SQL Server 2012 R2 Native Client must also be installed on the server on which PHP is running. To download and install SQL Server 2012 R2 Native Client now, click on the link below that matches the Windows edition on the web server: