Welcome to the LimeSurvey Community Forum

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

MSSQL Connection

  • BramFR
  • BramFR's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #185772 by BramFR
MSSQL Connection was created by BramFR
I have install a fresh ubuntu 18.04 server with PHP 7.2 (with reetds-common and php7.2-sybase)

when i connect trough CLI everythings fine:
# root@78325f6f76bb:/var/www# tsql -H remote_ip -p 56672 -U username -P password -D limesurvey
locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "ISO-8859-1"
Setting limesurvey as default database in login packet
1>

But when i try to setup trough the "LimeSurvey installer" i`ll get this message:

Please fix the following errors:
Try again! Connection with database failed.
Reason: SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (remote_ip) (severity 9)

I have more instance with mssql server. So i have to use a port.
The topic has been locked.
  • BramFR
  • BramFR's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago - 4 years 10 months ago #185778 by BramFR
Replied by BramFR on topic MSSQL Connection
Fixed by change /etc/freetds/freetds.conf

[IP]
host = IP
Port = PORT
tds version = auto

change IP & PORT with the right information.
In the "LimeSurvey installer" only fill the IP without port.
Last edit: 4 years 10 months ago by BramFR.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose