Won't create database

More
2 years 5 months ago #119701 by fush
fush created the topic: Won't create database
I'm having issues with the database creation part of the setup wizard. I'm running IIS on Windows Server 2012 R2, PHP 5.6, SQL 2008 R2. I have the SQL PDOs installed and they're showing as enabled. I've installed both SQL Native Client 2008 and 2012. When I try to enter my SQL server info, it says "Connection with database failed. Please check database location, user name and password and try again." I know my login info is correct for the SQL server

Please Log in to join the conversation.

More
2 years 5 months ago #119702 by holch
holch replied the topic: Won't create database
Did you create the database already? I don't think Limesurvey is creating the database for you.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
2 years 5 months ago #119742 by fush
fush replied the topic: Won't create database
Yes I've tried both ways, without a database created and with a database created. Both get the same error.

Please Log in to join the conversation.

More
2 years 5 months ago #119747 by fush
fush replied the topic: Won't create database
Oh wow, okay I finally figured this out. I needed to install the Microsoft® ODBC Driver 11 for SQL Server located here: www.microsoft.com/en-us/download/details.aspx?id=36434

Once that was installed it was all good.
The following user(s) said Thank You: bnosie

Please Log in to join the conversation.

More
2 years 5 months ago #119760 by DenisChenu
DenisChenu replied the topic: Won't create database

fush wrote: Oh wow, okay I finally figured this out. I needed to install the Microsoft® ODBC Driver 11 for SQL Server located here: www.microsoft.com/en-us/download/details.aspx?id=36434

Once that was installed it was all good.

Can you search on our manual if you find someting on this ?
If not : can you improve our manual adding it ?

manual.limesurvey.org/Installation_FAQ here maybe

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
2 years 5 months ago #120055 by bnosie
bnosie replied the topic: Won't create database
Did you have to do anything else other than install the ODBC driver? That didn't work for me. I already had ver 6 ODBC driver installed, and I installed ver 11. Still getting this error. I'm thinking I don't have the PDO driver configured correctly, but any documentation I find for this is rather sketchy.

Very frustrating. I am still running an instance of Limesurvey v 1.91 on a linux box because the SQL connection worked. Have never been able to get it to work from an IIS box, but really need to.

Please Log in to join the conversation.

More
2 years 5 months ago #120057 by bnosie
bnosie replied the topic: Won't create database
Update: I used a SQL account and it worked fine. I could not get an AD account to work.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now