if someone can explain me this - ODBC

From: Date: Tue, 06 Aug 2002 14:23:28 +0000
Subject: if someone can explain me this - ODBC
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-21010@lists.php.net to get a copy of this message
Hi! I used to connect to an SQL-Server from a Webserver on the same machine using an ODBC Data Source. This way I could make the user-authentification on NT-Basis like: odbc_connect("DSN","",""); everything worked fine until I wanted to build up a connection to an SQL-Server on a different machine.I changed absolutely nothing just the SQL-Server in the ODBC-DSN, and I got the error message: Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'., SQL state 28000 in SQLConnect in ... although the $_SERVER['AUTH_USER'] contained the right user, and it was surely not 'NT AUTHORITY\ANONYMOUS LOGON' ... Where is my user gone??? And then came the most interesting part: If I accessed the .php file locally from the server (with http://servername/xxx.php ,but from the server itself), the connection has been established. IS THERE a difference, if I access the server from itself, or from another computer in the network??? Can somebody explain me all this??? Best regards, Gabor

« previous php.db (#21010) next »