I have a MS SQL Server DB that I need to connect to from a linux box.
It appears that PHP is lacking the ability to connect to a mssql server if SQL Server has "with Windows NT Authentication using the Network Login ID" set.
The DB I'm attempting to connect to is currently set with NT Auth. We do not own a copy of SQL Server, so I can't put it into mixed mode. Other programs already use the DB, so it must stay in NT Auth mode.
I've installed apache and PHP on an NT box that can and does connect to the database via 3 other and different programs (windows .exes designed to connect to it). upon trying a simple PHP odbc script, I can see that PHP is attempting to loging using the machines name, but SQL Server is denying a connection.
Upon asking this question in a database forums (dbforums.com), someone said that in ASP, he has to "login with web auth".
Does PHP have this web auth for connection to NT domains? Again, I'm running the PHP program from a machine that is already on the network, but it appears as if SQL Server is looking for a bit more before it will allow you to connect.
