La extensión SQLSRV se activa añadiendo el fichero DLL apropiado al directorio de extensiones de PHP y la entrada correspondiente al fichero php.ini. La descarga de SQLSRV viene con 8 ficheros controladores, cuatro de ellos son para el soporte de PDO. Si se está ejecutando PHP (PHP 5.3) no seguro a nivel de hilos se ha de utilizar el fichero php_sqlsrv_53_nts.dll. (Se debería usar una versión no segura a nivel de hilos si se utiliza IIS como servidor web). Si se está ejecutando PHP seguro a nivel de hilos se ha de utilizar el fichero php_sqlsrv_53_ts.dll. De forma similar, para PHP 5.4, se ha de usar php_sqlsrv_54_nts.dll o php_sqlsrv_54_ts.dll, dependiendo de si la instalación de PHP no es segura a nivel de hilos o sí lo es, respectivamente.

La versión más reciente del controlador se puede descargar aquí: » Descarga de SQLSRV 3.0. Si se necesita soporte para PHP 5.2 y/o PHP compilado con VC6, se ha de usar la versión 2.0 del controlador: » Descarga de SQLSRV 2.0.

Para más información sobre los requerimientos de SQLSRV, ver » Requerimientos del Sistema para SQLSRV.

La extensión SQLSRV solamente es compatible con PHP corriendo sobre Windows.

add a note add a note

User Contributed Notes 8 notes

shastry dot sushruth at example dot com
8 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
remove dot four dot english dot rk at ee39 dot words dot de
1 month 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
SQLSRV doesn't use mssql_connect - it is it's own extension, therefore to connect you'd use sqlsrv_connect:
1 year ago
The latest version of the driver is available here :
This version supports PHP 5.5.
7 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:
veera3189 at gmail dot com
2 years ago
i tried the above steps

but  the following error came

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\php\1.php on line 12

what to do?
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