Dear community,

On my Windows 12r2 server I've installed IIS, PHP using Microsoft's wpilauncher.exe and chose to install PHP version 7.0.9, I've checked if my PHP installation and it was a success. I've unpacked the Limesurvey files to my wwwroot folder.
I've tried to install the mssql driver for php but had to choose between 4 or 5 executables and could not find any resource telling me the one to choose. I chose SQLSRV40.EXE and run it and let it drop the files in the C:\Program Files\PHP\v7.0\ext folder. I gambled what file to load in the php.ini and added it using the line:

extention=php_sqlsrv_7_ts_x64.dll

I've rebooted the server and started the Limesurvey installation script and all went well until I had to choose the database type and could not choose any other than MySQL.
I’d like to choose the type MSSQL but what should I do to make this work?


Regards,

Frans

In general I don't recommend to go for the windows stack. From what I can see, most developers work purely on Linux stacks and thus Limesurvey works far better with that.

Now to your problem: I think the problem is that you don't have the correct database driver. I think there have been similar issues in the past here in the forum. Have a search regarding mssql in the forum, there are quite a few posts on it:
www.limesurvey.org/forum/installation-a-...ssql-with-limesurvey
www.limesurvey.org/forum/installation-a-...-sqlexpress-database
manual.limesurvey.org/Troubleshooting
manual.limesurvey.org/Installation

... MSSQL (pdo_sqlsrv for Windows and pdo_dblib for Linux)

then not php_sqlsrv_7_ts_x64.dll but something like php_pdo_sqlsrv_XX_YYY.dll

PS : source : manual.limesurvey.org/Installation#Make_...rvey_on_your_website please : Read the manual ....

FransErich wrote: I've rebooted the server and started the Limesurvey installation script and all went well until I had to choose the database type and could not choose any other than MySQL.

What version/build of LimeSurvey is used?
Can you provide a screenshot of where you aren't able to choose something different than MySQL.

LimeSurvey uses the PDO database driver.
In your installation LimeSurvey should connect from a Windows system to a SQLServer installed on a Windows system.

To get an impression about what PDO dll needs to be used, take a look at:
docs.microsoft.com/en-us/sql/connect/php...r-the-php-sql-driver

Educated guess:
Please try php_pdo_sqlsrv_7_ts_x64.dll or php_pdo_sqlsrv_7_nts_x64.dll



Microsoft work in progress drivers:
github.com/Microsoft/msphpsql/