• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook pagefor updates, or we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.)

Configure SQLSRV on WEBENGINE Sucessfully

Newbie Spellweaver
Joined
Mar 19, 2015
Messages
79
Reaction score
4
1)Delete all instances and registers of SQL Server, or more agressive way: format PC/Virtual machine and start again all over.

2) Install Xampp 7.1

3) Download and place these DLL on "C:\xampp\php\ext" and take note of the names of the DLL

4) Very important: Go to PHP.ini and put exactly the name of the DLL Extension you wish to activate, not just "extension=php_pdo_sqlsrv.dll". You have to put "extension=php_sqlsrv_71_ts.dll" and "extension=php_pdo_sqlsrv_71.dll", or the exact name of your DLL for your PHP Version.

5)When you register the name of your instance of SQL On the installation, you need to put "PCNAME\INSTANCE" In my case its "SVPC\MUSV"

6)Add the executables of SQL to the firewall exceptions, only private, not public.
"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MUSV\MSSQL\Binn\sqlservr.exe"

"C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe"

Any question? i will happily answer and try to help.

I Speak spanish and english.
 
Experienced Elementalist
Joined
Jun 16, 2018
Messages
218
Reaction score
32
I'm using a xampp 5.6 32 bit and i download the php_sqlsrv_56_ts.dll , php_sqlsrv_56_nts.dll , do i need to rename the two dll in php_pdo_sqlsrv.dll and add it in php.ini in this line extension=php_pdo_sqlsrv.dll correct me if i'm wrong.
 
Junior Spellweaver
Joined
Dec 27, 2007
Messages
113
Reaction score
16
I'm using a xampp 5.6 32 bit and i download the php_sqlsrv_56_ts.dll , php_sqlsrv_56_nts.dll , do i need to rename the two dll in php_pdo_sqlsrv.dll and add it in php.ini in this line extension=php_pdo_sqlsrv.dll correct me if i'm wrong.

You do not need to rename the files, just make sure you've got the lines
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll

or whatever. The important thing is you have to include them on your php.in the way the files are called in the directory once you copy them in.
 
Back
Top