#31795 [NEW]: Permission issues with ntwdblib.dll and Windows 2003

From: sa at ruraltel dot net Operating system: Windows 2003 PHP version: 5.0.3 PHP Bug Type: MSSQL related Bug description: Permission issues with ntwdblib.dll and Windows 2003 Description: ------------ This issue is pertains to Windows 2003 and ntwdblib.dll 7.00.839 which has been the packaged dll in the previous 3 releases. Issue: Only an account on the MSSQL Server machine can have access to pass queries to the MSSQL i.e an account that has admin privileges on web server box (Windows 2003) and has privliges on the MSSQL box will allow the credentials to pass thus allowing the SQL login creditials to pass and the query to execute. While using Ethereal I noticed that the protocol used on Win 2k3 boxes accessing MSSQL was SMB and that it was performing NTLM authentication for the iusr_servname account against the MSSQL server. Where by the XP and 2000 box was using TDS with the same DLL. Once a changed the dll to the current version (ntwdblib.dll ver 8.00.194) running on the MSSQL box the apps worked normally on Win 2k3 boxes. Reproduce code: --------------- $test = mssql_connect('dbserver',"uname","pword"); if(!$test) { $return = 'Test Failed: '.mssql_get_last_message()."\n"; } else { $return = 'Test succeeded'; } Expected result: ---------------- Test Succeeded Actual result: -------------- Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 24.225.0.5 in D:\clients\admin.ruraltel.net\tmp\test_mssql.php on line 11 -- Edit bug report at http://bugs.php.net/?id=31795&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31795&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31795&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31795&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31795&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31795&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31795&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31795&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31795&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31795&r=support Expected behavior: http://bugs.php.net/fix.php?id=31795&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31795&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31795&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31795&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31795&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31795&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31795&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31795&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31795&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31795&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31795&r=mysqlcfg