SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

Hello everyone,

I have created a website with two databases: one using MySQL, where I can perform CRUD operations, and the other using MSSQL, which resides on a remote Windows server. Typically, the MSSQL database is only used for fetching data without any additional functions. However, I am encountering the error mentioned above. I have searched the internet extensively, but I have yet to find a solution.

Please find the version details below:

• Laravel Version: 10.39.0
• Web Hosting: Ubuntu 22.04
• PHP: 8.2.17
• pdo_sqlsrv/sqlsrv: 5.11.1
• ODBC Driver: 17
• SSL Version: OpenSSL/3.0.2
• SSL: LetsEncrypt

In the config/database.php file:

'world' => [
            'driver' => 'sqlsrv',
            'url' => env('DATABASE_URL'),
            'host' => env('WORLD_DB_SQLSRV_HOST', 'localhost'),
            'port' => env('WORLD_DB_SQLSRV_PORT', '1433'),
            'database' => env('WORLD_DB_SQLSRV_DATABASE', 'forge'),
            'username' => env('WORLD_DB_SQLSRV_USERNAME', 'forge'),
            'password' => env('WORLD_DB_SQLSRV_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
	        'prefix_indexes' => true,
            'options' => [
                'Encrypt' => true, 
            ],

I hope someone can assist me with my problem.

Regarding the suggestion found on the internet to edit the openssl.cnf file, I am concerned about compromising the server's security. However, I did try changing the CipherString = DEFAULT@SECLEVEL configuration from 2 to 0, and it worked on my end. Would this compromise server security if I proceed with this change?