Windows Authentication connection string for PHP

• P Corbett

  Old Hand

  Points: 357

  More actions

  November 15, 2006 at 9:08 am

  #114197

  I'm looking to connect to a LAN SQL Server 2000 box with PHP using Windows authentication. Has anyone had any success doing so?

  I have one locally working, but that is with SQL Server Auth. The connection string format I am familiar with for connecting with sql server auth is:

  $dbCon = 'mssql://userName:passWord@servr/database';

  Any ideas?

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  November 15, 2006 at 9:23 am

  #672022

  Are you looking to do windows integrated or just pass a domian username/PW combo?

  You could consider using an ODBC datasource as well...

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• P Corbett

  Old Hand

  Points: 357

  More actions

  November 15, 2006 at 9:50 am

  #672041

  I'm looking to do a windows integrated. I'm looking into the ODBC option now, but does that require that a DNS be setup? The dba here is requiring me to connect to the db using windows auth and has not set up a DSN.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  November 15, 2006 at 11:03 am

  #672063

  yes the odbc datasource would be a DSN either on your server or on the client machines depending on how you are setting up your application.

  u could have a look at http://builder.com.com/5100-6371-5160904.html for connecting via a DSN with windows Authentication.

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• P Corbett

  Old Hand

  Points: 357

  More actions

  November 15, 2006 at 11:13 am

  #672066

  Okay, I'll take a look at that. Maybe the dba here will set one up, but I doubt it. Does anyone know of a way of doing this w/o odbc?