Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

MSSQL installation

  • josueOrellana
  • josueOrellana's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 4 months ago - 6 years 4 months ago #161323 by josueOrellana
MSSQL installation was created by josueOrellana
Good Day,

I have the current scenario, I have a web server Debian8 with Apache 2.4.10 and PHP 5.6 and also have in other server a Database Server MSSQL 2016, anyone know how I can install limesurvey in this scenario (have the app in the web server and the database in MSSQL).
Because when I tried to install it the only option available is MySQL, but according to the documentation is possible to install Limesurvey with the database in MSSQL.

Thank you very much in advanced.
Last edit: 6 years 4 months ago by josueOrellana.
The topic has been locked.
More
6 years 4 months ago #161356 by jelo
Replied by jelo on topic MSSQL installation

josueOrellana wrote: Because when I tried to install it the only option available is MySQL, but according to the documentation is possible to install Limesurvey with the database in MSSQL.

Which version/build of LimeSurvey do you try to install? Can you provide a screenshot of the database selection screen?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • josueOrellana
  • josueOrellana's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 4 months ago #161357 by josueOrellana
Replied by josueOrellana on topic MSSQL installation
Good day, here the details:

limesurvey version => 2.72.5+171121

The screenshots are attached to this response
The topic has been locked.
More
6 years 4 months ago #161362 by jelo
Replied by jelo on topic MSSQL installation
You should check, if your PHP installation is using the MSSQL database extentions.

php.net/manual/mssql.installation.php
github.com/Microsoft/msphp

You might consult a debian forum for further infos about debian 8 and php pdo mssql
php.net/manual/ref.pdo-dblib.php

When PHP is able to connect to MSSQL database I would expect that the LimeSurvey installer will offer MSSQL beside MySQL.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: josueOrellana
The topic has been locked.
  • josueOrellana
  • josueOrellana's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 4 months ago - 6 years 4 months ago #161376 by josueOrellana
Replied by josueOrellana on topic MSSQL installation
You were right, now I getting this issue (attached image) I also test from console and everything went as expected, but when I tried from the app I got the error. Is there anything else that I should set up?
Last edit: 6 years 4 months ago by josueOrellana.
The topic has been locked.
More
6 years 4 months ago #161403 by jelo
Replied by jelo on topic MSSQL installation
Ensure that the connection between the webhost server and the MSSQL server is not blocked.
Ports open? Access might be blocked if the webhost is not on a whitelist.
stackoverflow.com/questions/31818839/php...erver-is-unavailable

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: josueOrellana
The topic has been locked.
More
6 years 4 months ago #161417 by fvanderstarre
Replied by fvanderstarre on topic MSSQL installation
You may also have to install the FreeTDS driver on your webserver.
The following user(s) said Thank You: josueOrellana
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose