problem with many connections from RHEL 8.10 to mssql server

Posted on

I have simple script:

for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
done

We upgraded OS from RHEL 7.9 to 8.10.
Now, when I execute it 99% of the connections are OK, BUT some of them end in error:

SQL> [08001][Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x2746 [08001][Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection

Such amount of connections are needed in one of SAS programs. 100% of successful connections were in the RHEL 7.9 release.
Can you advice if there is a parameter in Linux, or maybe some ODBC, OPENSSL to have it working again?
Any advice is very appreciated.

I have tried rolling back to RHEL 7.9 and the script is working without any issues

JK

Responses