View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
11709Bug reportsInstallationpublic2016-09-26 07:432016-09-27 16:21
ReporterElMatador69 Assigned Toc_schmitz  
PrioritynoneSeverityblock 
Status closedResolutionno change required 
Product Version2.52.x 
Summary11709: Error running LimeSurvey Installer on MSSQL
Description

I'm referrering to this forum thread:
https://www.limesurvey.org/forum/installation-a-update-issues/107121-error-running-limesurvey-installer-on-mssql

I try to run the LimeSurvey Installer, but I get the following error after hitting "´Next" on the fourth step of the installer to configure the database credentials:
Fatal error: Invalid handle returned. in C:\apache\htdocs\survey\application\controllers\InstallerController.php on line 1336

Steps To Reproduce

Scenario:

  • Windows Server 2012 R2
  • Apache httpd-2.4.23-x64-vc14-r2
  • MSSQL Server 2014
  • php-7.0.11-Win32-VC14-x64
  • using "sa" account for MSSQL database; but the error can also be reproduced, if I created a new user with a simple user name and a very simple password
  • LimeSurvey database name: LimeSurvey01 ==> doesn't matter if database exists or doesn't exist running the installer
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)limesurvey2.52+160920
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL Server 2014
Server OS (if known)Windows Server 2012 R2
Webserver software & version (if known)Apache httpd-2.4.23-x64-vc14-r2
PHP Versionphp-7.0.11-Win32-VC14-x64

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-09-27 15:43

administrator   ~40979

It is a bug in the MSSQL PHP driver - see https://github.com/Microsoft/msphpsql/issues/116 - if you update to the latest version of the MSSQL driver it should be fine.
ElMatador69

ElMatador69

2016-09-27 16:03

reporter   ~40981

I can confirm using the PHP MSSQL driver "php_pdo_sqlsrv_4.1.1_x64" instead of "4.0.8629.2" fixed my issue.

@ c_schmitz: thx a lot for your support!
c_schmitz

c_schmitz

2016-09-27 16:21

administrator   ~40982

You are most welcome, my old friend :-)

Issue History

Date Modified Username Field Change
2016-09-26 07:43 ElMatador69 New Issue
2016-09-27 15:43 c_schmitz Assigned To => c_schmitz
2016-09-27 15:43 c_schmitz Status new => closed
2016-09-27 15:43 c_schmitz Resolution open => no change required
2016-09-27 15:43 c_schmitz Note Added: 40979
2016-09-27 16:03 ElMatador69 Note Added: 40981
2016-09-27 16:21 c_schmitz Note Added: 40982