Online Chat
 Call Us: 
1-877-744-1221
Browse Submit a Ticket
 
Advanced Search
Tools
Rss Categories

PHP drivers for Microsoft SQL (Windows 2008/2012/7/8 + IIS7/IIS7.5/IIS8)

Author: Edward Hardin Reference Number: AA-00718 Views: 27311 Last Updated: 04/27/2017 04:19 PM 0 Rating/ Voters

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:

php_sqlsrv_56_nts.dll

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):

extension=php_sqlsrv_56_nts.dll

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.

Install the ODBC Driver. Download x86 or x64 depending on your Windows edition.

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:



Custom Fields
This article applies to the following versions of Knowledgebase Manager Pro:6.0, 6.0.1, 6.0.2, 6.0.3,6.1.*
Applicable to these operation systems:Windows
Database type:MS SQL