php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: jmelville at selectaustralasia dot com dot au
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-21 12:43 UTC] 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-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-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 12:01:31 2024 UTC