LS Database Connection with MS SQL Windows Authentication

More
3 years 1 month ago #113973 by gotanproject
gotanproject created the topic: LS Database Connection with MS SQL Windows Authentication
Hi!

I'm trying to use LS with MS SQL Server Windows Authentication. Everything seems to work fine when I use SQL Server Authentication, but whenever I change the config.php with a windows authentication LS fails to connect. And SQL Server error log suggests LS is still trying to connect via SQL Server Authentication.

Does anyone know how I can setup the LS Database connection with Windows Authentication instead of SQL Server Authentication? :unsure:

Thanks!!

Gotan

Please Log in to join the conversation.

More
3 years 1 month ago #113974 by DenisChenu
DenisChenu replied the topic: LS Database Connection with MS SQL Windows Authentication
Something here:
manual.limesurvey.org/Authentication_plu...s_AD2008_.26_2.05.2B

ANd yes : default LS authentification is LS authentification.

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
3 years 1 month ago #113975 by gotanproject
gotanproject replied the topic: LS Database Connection with MS SQL Windows Authentication
Thank you for your quick response! I'm not having any issues with LDAP plugin; it works well.

I'm having issue using Windows Authentication for LS Database Connection. Could you please clarify if this is possible? I do not want LS to use SQL Server Authentication.

Gotan

Please Log in to join the conversation.

More
3 years 1 month ago #113977 by DenisChenu
DenisChenu replied the topic: LS Database Connection with MS SQL Windows Authentication
Windows Authentication => AuthLDAP plugin

There are no user auto creation with LDAP plugin ( see github.com/LimeSurvey/LimeSurvey/pull/225 )

I can not be more clear .

For example, you put : "When i update config.php" : what did you put in your condif.php file ? Whta is your LS version ? What do you want exactly.

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
3 years 1 month ago #113978 by gotanproject
gotanproject replied the topic: LS Database Connection with MS SQL Windows Authentication
More specifically, I believe the below database config.php file needs to be changed from current SQL Server Authentication to something else which I have yet to find-

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
return array(
'components' => array(
'db' => array(
'connectionString' => 'sqlsrv:Server=xxxxxx;Database=xxxxxx',
'username' => 'xxxxxx',
'password' => 'xxxxxx',
........


Any idea how I can change this to force windows authentication for database connectivity? Is this possible?

Thanks!
Gotan

Please Log in to join the conversation.

More
3 years 1 month ago #113979 by gotanproject
gotanproject replied the topic: LS Database Connection with MS SQL Windows Authentication
ls version is 2.05 with sql server. I just want LS to use Windows Authentication for LS to "connect to my mssql database". But the below config.php for sql server is forcing sql server authentication.

Please let me know if this does not clarify your questions.

Thanks again,
Gotan

Please Log in to join the conversation.

More
3 years 1 month ago #113981 by DenisChenu
DenisChenu replied the topic: LS Database Connection with MS SQL Windows Authentication
OK,

More a Yii system then.

See www.yiiframework.com/wiki/192/config-use...ql-server-2005-2008/
And the comment

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 .
The following user(s) said Thank You: gotanproject

Please Log in to join the conversation.

More
3 years 1 month ago #114042 by DenisChenu
DenisChenu replied the topic: LS Database Connection with MS SQL Windows Authentication

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 .
The following user(s) said Thank You: gotanproject

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!