php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #23218 Trusted connections to MSSQL server fail intermittently
Submitted: 2003-04-14 22:09 UTC Modified: 2003-04-24 03:04 UTC
From: jmelville at selectaustralasia dot com dot au Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.3.1 OS: Windows 2000 Server
Private report: No CVE-ID: None
 [2003-04-14 22:09 UTC] 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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-14 22:10 UTC] jmelville at selectaustralasia dot com dot au
(typo first line: I meant MSSQL)
 [2003-04-23 19:06 UTC] jmelville at selectaustralasia dot com dot au
Tested - this looks good, thanks! No problems so far.
 [2003-04-24 03:04 UTC] sniper@php.net
Closing then. (apparently fixed)

 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Thu May 19 19:04:05 2022 UTC