Bug #43888 [Com]: mssql_connect fails with an SSL enabled SQL server

Edit report at https://bugs.php.net/bug.php?id=43888&edit=1 ID: 43888 Comment by: arif dot shah at apperception dot co dot uk Reported by: tank dot is dot hank at gmail dot com Summary: mssql_connect fails with an SSL enabled SQL server Status: No Feedback Type: Bug Package: MSSQL related Operating System: Windows 2003 PHP Version: 5.2.5 Block user comment: N Private report: N New Comment: I am using PHP 5.3.10 and Microsoft's SQL Driver for PHP version 3.0 with following extensions enabled. extension=php_curl.dll extension=php_dblib.dll extension=php_gd2.dll extension=php_ldap.dll extension=php_mbstring.dll extension=php_mysql.dll extension=php_openssl.dll extension=php_pdo.dll extension=php_pdo_sqlsrv_53_nts_vc9.dll extension=php_sqlsrv_53_nts_vc9.dll extension=php_xmlrpc.dll Previous Comments: ------------------------------------------------------------------------ [2013-07-10 05:52:53] pajoye@php.net IIRC: We do not support PHP 5.2 anymore. MSSQL extension is not supported anymore either on 5.3+. We strongly recommend to move to the SqlSrv extension (http://pecl.php.net/sqlsrv) developed by the SqlServer team itself. ------------------------------------------------------------------------ [2013-07-10 05:35:36] arif dot shah at apperception dot co dot uk I am having the same problem.I have 'mssql.secure_connection' enabled but if I am not wrong this is irrelevant as the comment in php.ini refers to this with NT Authentication. I am using SQL Server authentication. If I turn 'Force Encryption' off at SQL Server then everything works fine. My config is as below: Web Server: Windows 2008, IIS 7, PHP 5.3.10 x64 CGI/FastCGI DB Server: Windows 2008, SQL Server 2012, Mixed Authentication I also have an asp.net application in the same environment which runs perfectly fine with and without encryption. ------------------------------------------------------------------------ [2009-01-15 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2009-01-07 18:07:38] kalle@php.net Have you set the mssql.secure_connection ini option to true? ------------------------------------------------------------------------ [2008-01-18 12:26:42] hack dot is dot tank at gmail dot com An ODBC connection seems to work, which I believe will fix the problem for me. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=43888 -- Edit this bug report at https://bugs.php.net/bug.php?id=43888&edit=1