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.