Post reply

Windows Authentication connection string for PHP

  • 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?

  • 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]

  • 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.

  • 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]

  • 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?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply