Check out the LimeSurvey source code on GitHub!

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008

More
3 years 10 months ago #94758 by tbrice18
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 to join the conversation.

More
3 years 10 months ago #94759 by helper
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?

Please Log in to join the conversation.

More
3 years 10 months ago #94760 by tbrice18
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.

Please Log in to join the conversation.

More
3 years 10 months ago #94761 by tbrice18
I should also mention I have version 2.00+, Version 130406.

Please Log in to join the conversation.

More
3 years 10 months ago #94764 by helper
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 to join the conversation.

More
3 years 10 months ago #94791 by tbrice18
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 to join the conversation.

More
3 years 10 months ago - 3 years 10 months ago #94792 by helper
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.
Last Edit: 3 years 10 months ago by helper. Reason: cpy and past error

Please Log in to join the conversation.

More
3 years 10 months ago #94793 by tbrice18
No luck, when I changed the extension I got an error message saying drivers were not installed properly.

Please Log in to join the conversation.

More
3 years 10 months ago #94794 by tbrice18
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 to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form