Welcome to the LimeSurvey Community Forum

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

Internal Server Error dealing with collation and SQL Server 2012 database

  • jestrada
  • jestrada's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 3 months ago #129796 by jestrada
Internal Server Error dealing with collation and SQL Server 2012 database was created by jestrada
. Need help correctly configuring PHP mbstring and iconv for LimeSurvey to use SQL Server
2012 SP1 as its database. SQL Server is running on a Windows Server 2012 R2
instance in the Amazon Cloud. Actually I need help configuring all LimeSurvey peculiar settings for it to
consistently connect to and use a SQL Server 2012 SP1 database instance..

. LimeSurvey will be used by English speaking persons.

File Attachment:

File Name: limesurvey...tion.txt
File Size:34 KB

. LimeSurvey will be installed to a Linux EC2 instance in the Amazon Cloud

. After an "successful" install, I am unable to login as 'admin'. I am getting some sort of
collation error. At the very BOTTOM of the attachment you will see the specific error msg I am receiving.

Thank you!
Joseph J. Estrada
Attachments:
The topic has been locked.
More
8 years 3 months ago #129804 by fvanderstarre
Replied by fvanderstarre on topic Internal Server Error dealing with collation and SQL Server 2012 database
Hi,
You may need to install FreeTDS (or have it installed) on your Linux server.
Entry for your db server in /etc/freetds.conf should look like:

[your-db-server-name]
host = your-db-server-name
port = 1433
tds version = 8.0
client charset = UTF-8

Cheers, Frank
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source