- Posts: 9
- Thank you received: 0
- Forum
- English support forums
- Installation & update issues
- Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
5 years 2 weeks ago #94758
by tbrice18
tbrice18 created the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
So far after perusing this forum it appears that LS does not function on a Windows server with the database residing on SQL 2008 Server. If that is the case, I do think it should be documented somewhere othere than users posting for answers which never come.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94759
by helper
helper replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
I have several LimeSurvey implementations on Windows 2008r2 running with SQL Server 2008. I am currently at Version 2.00+ Build 130406.
Just what issues are you experiencing? Can you get through the installation?
Just what issues are you experiencing? Can you get through the installation?
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94760
by tbrice18
tbrice18 replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
Hi Helper, so glad to see you 
No, I have not gotten past the installation. When I run the install package, in the drop down list I only get the MySQL choice for servers and I don't have MYSQL so I am experiencing difficulty in trying to connect to the database. It would be greatly appreciated if you could point me in the right direction. Thank you so much.

No, I have not gotten past the installation. When I run the install package, in the drop down list I only get the MySQL choice for servers and I don't have MYSQL so I am experiencing difficulty in trying to connect to the database. It would be greatly appreciated if you could point me in the right direction. Thank you so much.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94761
by tbrice18
tbrice18 replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
I should also mention I have version 2.00+, Version 130406.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94764
by helper
helper replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
As I remember, we had this issue to begin with also. I believe that you need to install the 3.0 MS SQL Server driver (
www.microsoft.com/en-us/download/details.aspx?id=20098
). Do not forget to restart your server after you install the driver.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94791
by tbrice18
tbrice18 replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
Thank you for the response, however, installing the driver was one of the first tasks I performed when troubleshooting the issue. Still no luck.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago - 5 years 2 weeks ago #94792
by helper
helper replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
Try changing your extension definition:
extension=php_sqlsrv_53_nts.dll
Also, somewhere else in your php.ini you should also have a setting like the following that points to your ext directory for PHP:
extension_dir="C:\PHP\ext"
Again... with all of the above, you may want to restart your server.
extension=php_sqlsrv_53_nts.dll
Also, somewhere else in your php.ini you should also have a setting like the following that points to your ext directory for PHP:
extension_dir="C:\PHP\ext"
Again... with all of the above, you may want to restart your server.
Last Edit: 5 years 2 weeks ago by helper. Reason: cpy and past error
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94793
by tbrice18
tbrice18 replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
No luck, when I changed the extension I got an error message saying drivers were not installed properly.
Please Log in or Create an account to join the conversation.
5 years 2 weeks ago #94794
by tbrice18
tbrice18 replied the topic: Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008
Thank you for all of your help. I am going to investigate alternatives that may be a bit more "friendly" for my needs.
Please Log in or Create an account to join the conversation.