note 59347 added to function.mssql-connect

PHP 4.4.1 - IIS/6.0 - Windows 2K3 SP1 - MSSQL 2K connection problem mssql_connect() refused to connect on 1 machine (IIS/6.0 on Windows Server 2003SP1), but connected okay on 2 other machines (IIS/6.0 both on Windows 2003). One of those 2 machines had MS SQL Server 2000SP3 installed, the other did not -- neither had problems connecting to another, different Windows 2003 server running SQL2000 SP3. I fixed the problem on the broken Windows 2003SP1 server by replacing the bundled ntwdblib.dll in my php installation directory with the version of the .dll that I found in c:\windows\system32 on a system with MS SQL 2000 installed. I did not copy the .dll to c:\windows\system32 on the Web Server, just to the php install directory. After capturing the packets going between the web server and the database server on both configurations, I discovered that the broken system was trying to authenticate using SMB; the working configuration was using the MSSQL TDS protocol. Another consideration might be that in the working configurations, IIS was running as a domain user, while the broken configuration was running under the local IUSR account. ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+59347 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+59347&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+59347&report=yes Search -- http://master.php.net/manage/user-notes.php