When moving from Native Client 11 to MSOLEDBSQL 19, I did some testing of secure connection.

In my case, we have to specify the full network name of the database server. As others have mentioned, the database server must be configured correctly as well.

Take a look at this.  It walks you through what you need to do, including a certificate

What's New in PowerBuilder 2022 R2 – Part 2

https://www.youtube.com/live/H87gpnEt3mU?feature=shared&t=1860

You are missing bullet #3... "TDS 8.0 must be enabled and certificate must be configured."

All those requirements (3 bullets in documentation) must be met. 

Andreas.

AS mentioned in below screenshot. 

• MSOLEDBSQL SQL Server is required. (where client machine or DB server machine?)

• MSOLEDBSQL version must be 19.2.0 or higher (MSOLEDBSQL19 must be selected as Provider in the database profile). ( on Clinet machine?)

Do you have a certificate?

below is SQL Server manager setting on DB server which SQL server2022.

Hi.

This seems to be an issue related to SQL Server configuration... Don't know if this is the same but take a look at the following discussion:

SQL connection open failed when using MS OLE DB Driver 19 for SQL Server - Microsoft Q&A

Anyway, I would have the DBA look on what should be done in SQL Server to use TLS 1.3.

Andreas.

While making DB profile, I have selected MSOLEDBSQL SQL Server But when i test connection this issue occurred

Hi.

Yes. It is supported when connecting to SQL Server, but you have to use MSOLEDBSQL v. 19.2.0 or higher. Also this is supported in SQL Server 2022 version 16.0.4025.1 or higher. Take a look at the following link: Supporting TLS 1.3 - - Connecting to Your Database (appeon.com)

Andreas.