#23218 [Fbk->Opn]: Trusted connections to MSSQL server fail intermittently

ID: 23218 User updated by: jmelville at selectaustralasia dot com dot au Reported By: jmelville at selectaustralasia dot com dot au -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.3.1 New Comment: Tested - this looks good, thanks! No problems so far. Previous Comments: ------------------------------------------------------------------------ [2003-04-21 12:43:39] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2003-04-14 22:10:00] jmelville at selectaustralasia dot com dot au (typo first line: I meant MSSQL) ------------------------------------------------------------------------ [2003-04-14 22:09:27] jmelville at selectaustralasia dot com dot au 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 this bug report at http://bugs.php.net/?id=23218&edit=1