- Posts: 3
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
New installation on IIS won't connect to MSSQL database
- techturtle
- Topic Author
- Offline
- New Member
Less
More
1 month 2 weeks ago #258316
by techturtle
New installation on IIS won't connect to MSSQL database was created by techturtle
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.4.10
Own server or LimeSurvey hosting: Own Server (IIS/MSSQL)
Survey theme/template:
==================
We have a 2.5 version of Lime running on a server we're trying to retire. I have a Windows 2019 server running with IIS, including PHP 8.3.2 and LimeSurvey 6.4.10 installed. When I access the LimeSurvey folder through the browser, it prompts me to start the installation. All the pre-checks pass with minimum or exceeds requirements. However, once I get to the database page, it never connects correctly. We would like to just use the old database but are willing to create a new one. The database login is a MSSQL login account that is still functioning for our old version surveys. In the installer, it doesn't seem to be even attempting to connect (nothing shown in database logs, even with bad credentials entered). It never finds the old database, and when I say to create one it always shows as failed and suggests checking credentials. No attempts to create are logged in the SQL Server. The database is on a custom port but we have tried all of the following with no noticeable change:
servername
servername:port
servername,port (this is how it looks on the old server config.php)
servername.domain.local
servername.domain.local:port
servername.domain.local,port
IPaddress
IPaddress:port
IPaddress,port
Any help would be appreciated. Is there something specific that I needed to do in IIS to set this up? The installer just started running when the LimeSurvey folder was put in the default site location. I don't think we did any customization to it in IIS, and nothing in PHP beyond enabling all the required add-ons. I know we don't have any internal firewall blocks between the IIS server and the DB server because we have other apps running on that IIS install that talk to the database just fine. Is there any way that I can bypass the browser installation and just configure it manually?
Your LimeSurvey version: 6.4.10
Own server or LimeSurvey hosting: Own Server (IIS/MSSQL)
Survey theme/template:
==================
We have a 2.5 version of Lime running on a server we're trying to retire. I have a Windows 2019 server running with IIS, including PHP 8.3.2 and LimeSurvey 6.4.10 installed. When I access the LimeSurvey folder through the browser, it prompts me to start the installation. All the pre-checks pass with minimum or exceeds requirements. However, once I get to the database page, it never connects correctly. We would like to just use the old database but are willing to create a new one. The database login is a MSSQL login account that is still functioning for our old version surveys. In the installer, it doesn't seem to be even attempting to connect (nothing shown in database logs, even with bad credentials entered). It never finds the old database, and when I say to create one it always shows as failed and suggests checking credentials. No attempts to create are logged in the SQL Server. The database is on a custom port but we have tried all of the following with no noticeable change:
servername
servername:port
servername,port (this is how it looks on the old server config.php)
servername.domain.local
servername.domain.local:port
servername.domain.local,port
IPaddress
IPaddress:port
IPaddress,port
Any help would be appreciated. Is there something specific that I needed to do in IIS to set this up? The installer just started running when the LimeSurvey folder was put in the default site location. I don't think we did any customization to it in IIS, and nothing in PHP beyond enabling all the required add-ons. I know we don't have any internal firewall blocks between the IIS server and the DB server because we have other apps running on that IIS install that talk to the database just fine. Is there any way that I can bypass the browser installation and just configure it manually?
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 month 2 weeks ago #258324
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic New installation on IIS won't connect to MSSQL database
Is the PDO database driver installed?
manual.limesurvey.org/Installation_-_Lim...rvey_on_your_websitePDO database driver for MySQL (pdo_mysql or pdo_mysqli) or Postgres (pdo_pgsql) or MSSQL (pdo_sqlsrv for Windows and pdo_dblib for Linux).
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- techturtle
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
1 month 2 weeks ago #258393
by techturtle
Replied by techturtle on topic New installation on IIS won't connect to MSSQL database
Yes, the PDO_SQLSRV is installed and detected by the installer.
Attachments:
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 2 weeks ago #258460
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic New installation on IIS won't connect to MSSQL database
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.
- techturtle
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
1 month 6 days ago #258854
by techturtle
Replied by techturtle on topic New installation on IIS won't connect to MSSQL database
That does sound like it could be the source of my issue. Is there any workaround for it, since the bug report has not been resolved yet?
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 month 6 days ago #258855
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic New installation on IIS won't connect to MSSQL database
Add your comments to the bug. More movement, more likely to get fixed.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 5 days ago #258870
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic New installation on IIS won't connect to MSSQL database
Currently ; i add manually the needed part at
github.com/LimeSurvey/LimeSurvey/blob/6d...rConfigForm.php#L584
It's a one time hack.
It's a one time hack.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.