View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07804 | Feature requests | Authentication | public | 2013-04-26 18:28 | 2026-11-19 19:12 |
| Reporter | joe_p | Assigned To | c_schmitz | ||
| Priority | normal | Severity | @50@ | ||
| Status | closed | Resolution | fixed | ||
| Summary | 07804: 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: There seems to be something within LimeSurvey that uses SQL Server authentication by default rather than allowing for using Windows authentication. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Git branch / Pull Request URL | |||||
|
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. |
|
|
As you described, Windows authentication for SQL Server works by leaving the database username and password empty in the configuration file after installation. Closing this request as you suggested; feel free to reopen it if you need this in the installer itself. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-04-26 18:28 | joe_p | New Issue | |
| 2014-03-19 15:45 | joe_p | Note Added: 29413 | |
| 2026-11-19 19:02 | c_schmitz | Assigned To | => c_schmitz |
| 2026-11-19 19:02 | c_schmitz | Status | new => closed |
| 2026-11-19 19:02 | c_schmitz | Resolution | open => fixed |
| 2026-11-19 19:12 | c_schmitz | Note Added: 87385 | |
| 2026-11-19 19:12 | c_schmitz | Bug heat | 2 => 4 |