November 15, 2006 at 9:08 am
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
November 15, 2006 at 9:50 am
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
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.
November 15, 2006 at 11:13 am
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