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 workstation to the 

Using this, you can get the currently logged in userid via server variables 
from IIS into PHP.

But you never get the user's password or are able to get anything into PHP that 
will automatically connect you to a database or other trusted data source.   If 
you connect to a web server and PHP on that server creates a connection to a 
database, then PHP needs to send login credentials (either hardcoded, pulled 
from another database based on the user's ID or something, or provided by the 
user via a web form).  I don't believe you can have PHP create a connection 
based on integrated authentication because PHP is sort of outside the whole 
windows security scheme.

You could configure the database to accept a connection from the PHP server's 
IP address and nowhere else and hardcode a password into PHP, or do other 
things like that.

Again, maybe I mis-assuming what your configuration is.  Mind giving us more 
detail on the process you're trying to fix?   Users connects to web server, web 
server makes ODBC connection (by what means?), etc..


= = = Original message = = =


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)'. Reason: Not associated with a trusted SQL Server connection.".
What it seems to tell me is it is correctly trying to make an integrated
auth connection to the database, but for some reason the current user's
credentials aren't being passed? Does anyone have insight into this?

<>< Ryan

PHP Database Mailing List (
To unsubscribe, visit:

Sent by ePrompter, the premier email notification software.
Free download at

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to