#23218 [NEW]: Trusted connections to MSSQL server fail intermittently

From: jmelville at selectaustralasia dot com dot au Operating system: Windows 2000 Server PHP version: 4.3.1 PHP Bug Type: MSSQL related Bug description: Trusted connections to MSSQL server fail intermittently I have trusted connections to a local MSSAL database failing intermittently. This happens on two different machines running W2K server SP3, IIS 5, SQL 2K server with SP3, PHP 4.3.1 as an ISAPI module. One is a single PIII box, the other dual PIII. I have mssql.secure_connection and mssql_allow_persistent both set to On in PHP.INI. The local IUSR_ user is allowed access to the database. I'm using persistent connections. All connections are TCP/IP. The site I'm working with opens one or two connections per page. There are usually 5 or 6 connections open at any one time; nobody else is connected to this database and it's only running under a very light load right now. This arrangement all works fine for a little while and then starts to fail with the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) The error seems to be associated with a single connection in the pool of available connections, as reloading the offending page will succeed and then fail again, usually every second or third time. Waiting a while and reloading seems to clear the error for a little while, but then it comes back. Changing to username & password connections works, but ideally I'd like to use trusted connections. -- Edit bug report at http://bugs.php.net/?id=23218&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=23218&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=23218&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=23218&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=23218&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=23218&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=23218&r=support Expected behavior: http://bugs.php.net/fix.php?id=23218&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=23218&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=23218&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=23218&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23218&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=23218&r=dst IIS Stability: http://bugs.php.net/fix.php?id=23218&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=23218&r=gnused