Enable MSSQL in PHP 5.4

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Enable MSSQL in PHP 5.4

Postby shanthini » 19. October 2013 06:43


My xampp version: 1.8.2 PHP version: 5.4.19 (Thread safe) - I need to enable MSSQL

I tried enabling MSSQL extension by referring the link http://community.apachefriends.org/f/viewtopic.php?f=16&t=49670

Below are the steps I followed

1. Downloaded SQLSRV30.EXE from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=20098
2. Copied php_sqlsrv_54_ts.dll and php_pdo_sqlsrv_54_ts.dll to ext dir
3. Added the extension line in php.ini
4. Restarted apache

When starting apache this is showing the error - Specified module could not be loaded for php_sqlsrv_54_ts.dll and


Kindly advice on this

Posts: 6
Joined: 07. August 2010 07:43

Re: Enable MSSQL in PHP 5.4

Postby hackattack142 » 21. October 2013 22:15


See here fore a complete list of instructions: viewtopic.php?f=16&t=54978&p=208423&hilit=sqlsrv#p208423

My guess, based on your list and assuming you have a compatible OS (not Windows XP/Windows Server 2k3), is that you did not install the native client.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Enable MSSQL in PHP 5.4

Postby shanthini » 22. October 2013 07:25

Thanks for your reply. My OS is windows 7

I downloaded sqlncli.msi, Whether I need to install the package fully. It shows 19MB as disk cost
Can I install necessary features alone. My requirement is connect to the MSSQL DB, query it, doing insert delete and update.
Kindly advise for this what are the necessary features and how to select these features and install.

Posts: 6
Joined: 07. August 2010 07:43

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 29 guests