Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

LS Database Connection with MS SQL Windows Authentication

  • gotanproject
  • gotanproject's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #113973 by gotanproject
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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #113974 by DenisChenu
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • gotanproject
  • gotanproject's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #113975 by gotanproject
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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #113977 by DenisChenu
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • gotanproject
  • gotanproject's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #113978 by gotanproject
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
The topic has been locked.
  • gotanproject
  • gotanproject's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #113979 by gotanproject
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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #113981 by DenisChenu
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 , plugin development .
I don't answer to private message.
The following user(s) said Thank You: gotanproject
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #114042 by DenisChenu

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: gotanproject
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose