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

More
4 years 5 months 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 to join the conversation.

More
4 years 5 months 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?

Please Log in to join the conversation.

More
4 years 5 months 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.

Please Log in to join the conversation.

More
4 years 5 months 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 to join the conversation.

More
4 years 5 months 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 to join the conversation.

More
4 years 5 months 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 to join the conversation.

More
4 years 5 months ago - 4 years 5 months 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.
Last Edit: 4 years 5 months ago by helper. Reason: cpy and past error

Please Log in to join the conversation.

More
4 years 5 months 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 to join the conversation.

More
4 years 5 months 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 to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now