SQL server connection

[RameshSubramaniL]

SQL server connection

[v-makouz]

You can try setting MinProtocol to TLSv1.0 and CipherString to DEFAULT@SECLEVEL=0, but the best approach is to patch the server to support TLS 1.2

[d4em0nsp4wn]

I am having a similar issue, sqlcmd, isql, and even setting up the connection in PHP using "new PDO('odbc:Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.3.1;...connection string here);" works....but sqlsrv_connect fails with "Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server." code 26, sqlstate 08001; code 10054, [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746. A tcp dump shows proper TLSv1.2 handling with all tools mentioned above, however, a tcp dump with sqlsrv_connect shows only 8 packets before the connection is interrupted. The PHP environment is PHP 8.0.30. The same occurs regardless of using PHP 7.4 to 8.3. Also worth nothing the TCP dump shows the source and destination ports to be the same for every packet, whereas PDO, isql, and sqlcmd all have a randomized starting port. The sql instance is using a custom tcp port. The sql server requires TLS 1.2, and is SQL Server 2016.

[v-makouz]

Which operating system is this one?

[d4em0nsp4wn]

Which operating system is this one?

Cloudlinux/AlmaLinux 8. 64bit.

[v-makouz]

Does it give the same error when using only ODBC (isql, sqlcmd)? Or is it specific to PHP driver?

[d4em0nsp4wn]

Does it give the same error when using only ODBC (isql, sqlcmd)? Or is it specific to PHP driver?

The error is only specific when using the sqlsrv.so native module within PHP, isql, sqlcmd, and $pd = new PDO('odbc:Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.3.1;SERVER= dsn works just fine within PHP, but we are unable to use the PDO driver in this manner as the odbc function to permit multiple active results sets does not appear to work within PDO.
We specified both version 18 and version 17 and got the same errors out of the msphpsql modules.