Hello All, I am trying to use the windows authentication of the user surfing on the database I am connecting to. I have made myself a user on the database the ODBC DSN is pointing to.
Here is the script: <script language="php"> $db=odbc_pconnect("EOSTest", "", ""); $result=odbc_exec($db,"select system_user"); odbc_result_all($result); </script> When I surf to this page, I am presented with the login, at which I enter my username, password and domain. And here is the result: Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'., SQL state 28000 in SQLConnect in C:\Inetpub\Apps\provisioning\test.php on line 2 Warning: Supplied argument is not a valid ODBC-Link resource in C:\Inetpub\Apps\provisioning\test.php on line 3 Warning: Supplied argument is not a valid ODBC result resource in C:\Inetpub\Apps\provisioning\test.php on line 4 I have restricted the security on the page to just the domain admin group that I am in. So why would it be using an anonymous login? Something that may bear on this is that I had to uncheck "high encryption" in the ODBC configuration, because SQL Server did not support high encryption. Help! Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]