Welcome, Guest
Username: Password: Remember me

TOPIC: 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 1 year 3 months ago #94758

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
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.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94759

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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?
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94760

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
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.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94761

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
I should also mention I have version 2.00+, Version 130406.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94764

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94791

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
Thank you for the response, however, installing the driver was one of the first tasks I performed when troubleshooting the issue. Still no luck.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94792

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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: 1 year 3 months ago by helper. Reason: cpy and past error
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94793

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
No luck, when I changed the extension I got an error message saying drivers were not installed properly.
The administrator has disabled public write access.

Has anyone gotten LS to run on Windows 2008 IIS with database on SQL Server 2008 1 year 3 months ago #94794

  • tbrice18
  • tbrice18's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
Thank you for all of your help. I am going to investigate alternatives that may be a bit more "friendly" for my needs.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.115 seconds
Donation Image