#37232 [Asn->Bgs]: mssql_connect and mssql_pconnect do not accept password longer than 30 chars

ID: 37232 Updated by: fmk@php.net Reported By: rriehle at gmail dot com -Status: Assigned +Status: Bogus Bug Type: MSSQL related Operating System: XP SP2 PHP Version: 5.1.2 Assigned To: fmk New Comment: This is due to limmitations in ntwdblib from Microsoft. This library has not been updated since SQL server 6.5 where 30 was the max length of passwords etc. Use the php_dblib.dll extension. This is a dropin replacement build with FreeTDS. Previous Comments: ------------------------------------------------------------------------ [2006-04-28 06:03:00] rriehle at gmail dot com Description: ------------ Using SQL Server 2005 (SP1). Unable to connect with logins that have passwords greater than 30 characters long using mssql_connect or mssql_pconnect. The logins work fine from the server client tools; I spent hours troubleshooting this. sigh. The reason the passwords I was trying to use were 32 characters is becuase I was using MD5 hashes of plain passwords for my server logins. Reproduce code: --------------- $dbh = mssql_pconnect("MyHost", "testlogin", "passwordpasswordpasswordpassword"); OR $dbh = mssql_connect("BUILDWAY-NET", "testlogin", "passwordpasswordpasswordpassword"); Expected result: ---------------- Expect $dbh to hold a link identifier to a mssql connection. I expected that the statements would connect with passwords that have a length as long as the server can accept. Actual result: -------------- Returns false with these messages: Debug Warning: c:\Inetpub\wwwroot\includes\ez_sql-ms.php line 71 - mssql_pconnect() [<a href='file:///C:\Program Files\Zend\ZendStudioClient-5.1.0\docs\PHPmanual/function.mssql-pconnect'>function.mssql-pconnect</a>]: message: Login failed for user 'testlogin'. (severity 14) Debug Warning: c:\Inetpub\wwwroot\includes\ez_sql-ms.php line 71 - mssql_pconnect() [<a href='file:///C:\Program Files\Zend\ZendStudioClient-5.1.0\docs\PHPmanual/function.mssql-pconnect'>function.mssql-pconnect</a>]: Unable to connect to server: BUILDWAY-NET Errors are the same for mssql_connect (except that the p in mssql_pconnect is left out). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37232&edit=1