Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : mssqlnative configuration for windows integrated authentication

mssqlnative configuration for windows integrated authentication il y a 1 an 7 mois #93955

  • ddiemont
  • Portrait de ddiemont
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
I am trying to set up a copy of LimeSurvey 1.92 on a Windows Server 2008 R2 such that it connects to the SQL Server using the Application Pool Identity from the web server, rather than having the username/pwd of a SQL user stored in the config.php. I have the mssqlnative client configured (MS SQL Native Client 11; PHP 5.3.22 NTS, and Microsoft PHP Connection Drivers... changed $databasetpe to mssqlnaive), and I have commented out the databaseuser and databasepass variables in the config.php file, but when it attempts to connect to the database it appears to be using a 'root' user (The error I receive is "Can't connect to LimeSurvey database. Reason: 28000 Error Code: 18456 Message [Microsoft][SQL Server Native Client 11.0]Login failed for user 'root'")

My question: What do I files need to change to allow Integrated Authentication rather than SQL Authentication. From reading this (msdn.microsoft.com/en-us/library/ms130822.aspx) I believe that I need to add a "Trusted_Connection=yes" to the sql connection string that is being used, I'm just not sure where to find that.

Any help would be greatly appreciated.
r/
Derrick
L'administrateur a désactivé l'accès en écriture pour le public.

mssqlnative configuration for windows integrated authentication il y a 1 an 7 mois #94023

  • ddiemont
  • Portrait de ddiemont
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
got it.

in the adodb.mssqlnative.inc.php file connect function you can remove the User and Password components of the connection array (around line 380) and this force the application to use Windows Authentication.
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.118 secondes
Donation Image