PHP 5.6.30 Released


The SQLSRV extension is enabled by adding appropriate DLL file to your PHP extension directory and the corresponding entry to the php.ini file. The SQLSRV download comes 8 driver files, four of which are for PDO support. If you are running non-thread-safe PHP (PHP 5.3), use the php_sqlsrv_53_nts.dll file. (You should use a non-thread-safe version if you are using IIS as your web server). If you are running thread-safe PHP, use the php_sqlsrv_53_ts.dll file. Similarly for PHP 5.4, use the php_sqlsrv_54_nts.dll or php_sqlsrv_54_ts.dll depending on whether your PHP installation is non-thread-safe or thread-safe.

The most recent version of the driver is available for download here: » SQLSRV 3.0 download. If you need support for PHP 5.2 and/or PHP compiled with VC6, use the 2.0 release of the driver: » SQLSRV 2.0 download.

For more information about SQLSRV requirements, see » SQLSRV System Requirements.

The SQLSRV extension is only compatible with PHP running on Windows.

add a note add a note

User Contributed Notes 8 notes

shastry dot sushruth at example dot com
10 months ago
For some reason the default DLL files given at microsoft's website did not work for me. The author of this link : has compiled the same driver with different version of VC which worked for me. Just leaving a note for anyone who may be benefited
12 days ago
PECL packages for Linux SQLSRV and PDO_SQLSRV drivers (4.0.7) are available now.
2 years ago
SQLSRV doesn't use mssql_connect - it is it's own extension, therefore to connect you'd use sqlsrv_connect:
remove dot four dot english dot rk at ee39 dot words dot de
4 months ago
PHP Warning:  PHP Startup: Unable to load dynamic library '...\ext\php_sqlsrv_56_nts.dll' - %1 is not a valid Win32 application.

This error may occur if the Visual C++ runtime required by sqlsrv can not be found. In this case, "Visual C++ Redistributable for Visual Studio 2012 Update 4 (x86)" had to be installed for the x86 compiled PHP running on a x64 OS. For further investigations, have a look at Sysinternals Process Monitor.

2 years ago
The latest version of the driver is available here :
This version supports PHP 5.5.
10 months ago
Microsoft's PHP driver for SQL Server only runs with PHP 32-bit builds
michael dot endrizzi at gmail dot com
1 year ago
Error msg:
PHP Fatal error:  Call to undefined function sqlsrv_connect()

Make sure you load BOTH dll's listed in the README:
yahya kayhani
3 years ago
hi dear.
do step by step
1- un comment php_mssql.dll & php_pdo_mssql.dll in php.ini.template file(php directory in software install path)
2- Copy the ntwdblib.dll library from the php directory to the apache/bin directory.
3- Stop and start apache
4- test your mssql with phpinfo() function.
5- finish

Tech & Support by Yahya kayhani (IRAN-RASHT)
To Top