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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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: Mon Dec 30 17:01:29 2024 UTC