- Posts: 10
- Thank you received: 0
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
- Topic Author
- Offline
- New Member
Less
More
9 years 5 months ago #113973
by gotanproject
LS Database Connection with MS SQL Windows Authentication was created 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?
Thanks!!
Gotan
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?
Thanks!!
Gotan
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 5 months ago #113974
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.
Replied by DenisChenu on 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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
9 years 5 months ago #113975
by gotanproject
Replied by gotanproject on 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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 5 months ago #113977
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.
Replied by DenisChenu on 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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
9 years 5 months ago #113978
by gotanproject
Replied by gotanproject on 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
<?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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
9 years 5 months ago #113979
by gotanproject
Replied by gotanproject on 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 let me know if this does not clarify your questions.
Thanks again,
Gotan
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 5 months ago #113981
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.
Replied by DenisChenu on 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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 5 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.
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The following user(s) said Thank You: gotanproject
The topic has been locked.