View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
07804Feature requestsAuthenticationpublic2013-04-26 18:282014-03-19 15:45
Reporterjoe_p Assigned To 
PrioritynormalSeverity@50@ 
Status newResolutionopen 
Summary07804: LS still won't allow SQL Server to use Windows Authentication
Description

I opened issue 07801 with this. For some reason, downloading the current stable release of LimeSurvey gave me a RC9 version (even though I did this yesterday).

I have tried installation again with 2.05beta3 (build 130420) and 2.00+ (build 130423), and I still get the same issue with both.

My Windows log gives me this error:
Login failed for user ... Reason: Attempting to use an NT account name with SQL Server Authentication.

There seems to be something within LimeSurvey that uses SQL Server authentication by default rather than allowing for using Windows authentication.

TagsNo tags attached.
Bug heat2
Story point estimate
Users affected %

Users monitoring this issue

There are no users monitoring this issue.

Activities

joe_p

joe_p

2014-03-19 15:45

reporter   ~29413

This issue can be closed. In later releases of LimeSurvey, I have been able to set up Windows authentication, though it takes some extra steps beyond the LimeSurvey installer.

During the install process, I have to set my SQL Server to mixed-mode authentication (this is because the installer won't let both username and password be empty). Then after LimeSurvey has been installed, I go back to it and switch it back to Windows authentication, then go in and edit the config.php and set the username and password to empty strings.

Issue History

Date Modified Username Field Change
2013-04-26 18:28 joe_p New Issue
2014-03-19 15:45 joe_p Note Added: 29413