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 with Apache.

Supported PHP versions:

• PHP v5.3.6+
• PHP v5.4.*

Installation

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. You should use the Tread Safe version of PHP with Apache (if you're using a package like XAMPP, your PHP version is Tread Safe). If you're using PHP v5.3.6+, you would need this file:

Or if you're using PHP v5.4+ the file would be this one:

Copy the chosen file to the PHP extensions directory. By default it is C:\Program Files (x86)\PHP v5.4\ext or similar (for the latest XAMPP versions it is C:\xampp\php\ext by default). 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 (for PHP v5.3.6+):

Or

for PHP v5.4+.

Also, you would need to install Microsoft Visual C++ 2010 SP1 Redistributable Package (x86) on the web server.

Restart Apache.

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:

• Download the x86 package
• Download the x64 package

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 2003 and Windows XP with IIS6.

Supported PHP versions:

• PHP v5.2.13+
• PHP v5.3.6+

PHP must run via FastCGI (learn how to install PHP via FastCGI on IIS6).

Installation

Download the SQLSRV20.EXE file from the official Microsoft website. Please note that the other file, SQLSRV30.EXE, includes the drivers that do not support IIS6 - you do not need to download it. 

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 PHP 5.3.6+ compiled with VC9 x86 Non Thread Safe, so if you installed PHP using one of our guides (guide for IIS6) the file that you need is this one:

Otherwise, pick a file that matches your version of PHP using this table.

Copy the chosen 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 (if you're using other version of driver, adjust the setting accordingly):

Also, you would need to install Microsoft Visual C++ 2010 SP1 Redistributable Package (x86) on the web server.

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 2008 R2 Native Client must also be installed on the server on which PHP is running. To download and install SQL Server 2008 R2 Native Client now, click on the link below that matches the Windows edition on the web server:

• Download the x86 package
• Download the x64 package

KMP uses Microsoft's SQLSRV driver (PHP extension), to connect to a MSSQL database. This guide explains how to install this driver on Windows.

Supported PHP versions:

• PHP v5.4.32
• PHP v5.5.16+
• PHP v5.6.4+

PHP v7.* in not supported.

If you do not have PHP installed yet, follow this guide: PHP installation on IIS7, IIS7.5, and IIS8.

Installation

Download the SQLSRV32.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 extracted files. You need the php_sqlsrv_XX_nts.dll file, where XX is your PHP version, e.g. for PHP v5.6 Non Thread Safe you would need this driver:

Copy the driver file to the PHP extensions directory. 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:

• Microsoft Visual C++ 2010 SP1 Redistributable Package (x86)
• Microsoft Visual C++ Redistributable Packages for Visual Studio 2013

Restart the web server.

To check if 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:

You can use either mysqli or pdo_mysql PHP extension for connecting to the MySQL server. The instructions are simple, as follows.

mysqli

The php_mysqli.so extension must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in /etc/php5/cgi/), and make sure you remove the comment (semi-colon) from the start of the line:

Then you need to save the php.ini and restart the Apache.

pdo_mysql

PDO and PDO MySQL extensions must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in /etc/php5/cgi/), and make sure you remove the comment (semi-colon) from the start of the line:

Then you need to save the php.ini and restart the Apache.

You can use either mysqli or pdo_mysql PHP extension for connecting to the MySQL server. The instructions are simple, as follows.

mysqli

The php_mysqli.dll DLL must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in c:\php), and make sure you remove the comment (semi-colon) from the start of the line:

Then you need to save the php.ini and restart the web server.

pdo_mysql

The php_pdo_mysql.dll DLL must be enabled inside of php.ini. In order to do this you need to find the php.ini file (typically located in c:\php), and make sure you remove the comment (semi-colon) from the start of the line:

Then you need to save the php.ini and restart the web server.