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

Edit report at https://bugs.php.net/bug.php?id=43888&edit=1 ID: 43888 Updated by: pajoye@php.net 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: 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. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2008-01-18 09:06:30] tank dot is dot hank at gmail dot com Description: ------------ mssql_connect stopped working after we enabled SSL on our SQL server. The only error message we are getting is: Warning: mssql_connect(): Unable to connect to: OURSERVER.local in C:\site\DB.php on line 82 A sniffer shows it is able to open a connection to the server, but after a couple of seconds the connection is closed. We are able to connect using SQLCMD.EXE Reproduce code: --------------- mssql_connect('OURSERVER.local', 'myuser', 'mypass'); Actual result: -------------- Warning: mssql_connect(): Unable to connect to: OURSERVER.local in C:\site\DB.php on line 82 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=43888&edit=1