- Posts: 9
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
My installation script does not support database type MSSQL
- FransErich
- Topic Author
- Offline
- New Member
Less
More
7 years 1 month ago #148439
by FransErich
My installation script does not support database type MSSQL was created by FransErich
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
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
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11746
- Thank you received: 2750
7 years 1 month ago #148440
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic My installation script does not support database type MSSQL
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
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
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13912
- Thank you received: 2549
7 years 1 month ago - 7 years 1 month ago #148447
by DenisChenu
PS : source : manual.limesurvey.org/Installation#Make_...rvey_on_your_website please : Read the manual ....
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic My installation script does not support database type MSSQL
then not php_sqlsrv_7_ts_x64.dll but something like php_pdo_sqlsrv_XX_YYY.dll... MSSQL (pdo_sqlsrv for Windows and pdo_dblib for Linux)
PS : source : manual.limesurvey.org/Installation#Make_...rvey_on_your_website please : Read the manual ....
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 7 years 1 month ago by DenisChenu.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
7 years 1 month ago #148453
by jelo
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/
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic My installation script does not support database type MSSQL
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/
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.