Hi,
I have an intranet application that I wrote in PHP that has worked great
for a long time. It uses integrated authentication in IIS. I'm trying to
migrate to IIS 6 and things are mostly working. The problem I have is
that my ODBC_CONNECT calls are not resulting in: "Login failed for user
'(null
Maybe I'm not understanding the situation properly, because I can't see why you
would have had it working under IIS5 if your configuration is how I think it is.
Integrated authentication basically allows a workstation that's logged into a
domain to automatically pass it's credentials from the wo
Thanks for the response!
Yes, believe it or not it does work, or at least did on IIS 5. When I
turn on Integrated Security on the web server it causes PHP to run as
the user logged in instead of the Anonymous user. Then calling
odbc_connect with a blank username/password combination in cooperation
Ahh.. ok.. I was mostly doing DSNless connections.
You might want to look into the setup for your ODBC source called "Datasource"
in your example below. That might be what's actually passing the
authentication, not PHP itself. PHP makes a call to the local ODBC source
which in turn actually
You can always strip out the support for the DB's you're not going to
use. This should improve performance some. Also, ADODb is a great
abstraction layer, but we've found that we use less than half of its
fuctionality. It's great that the functionality is there, so you can
pare it down to your need
Here's an update. Running from a command prompt everything works fine.
Again, in ISAPI mode on IIS 6 this does not work. I just test CGI mode
with an identical result as ISAPI mode.
Here's the code that will generate the warning and fail to connect:
mySystemDSN is a system dsn with "With Windo
Well, isn't it always a minor detail that makes the difference? This
problem occurred because part of my upgrade included separating IIS and
my SQL server. Well, guess what, good ole' Microsoft has included a
"feature" that will not allow credentials to be passed from IIS to SQL
if SQL is on a diff