1. Amna Khalid
  2. PowerBuilder
  3. Friday, 27 September 2024 05:39 AM UTC

H Guys,

Can you please provide support on below query.

 

Does Appeon 2022 support TLS1.3?

When I configure ONLY TLS3 on client machine and on DB server both TLS and TLS3 is configured. Native Client 12 is installed on Client Machine. 

on Making Profile, below issue occurs. I want to run Application on TLS1.3.

Roland Smith Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 17:12 PM UTC
  2. PowerBuilder
  3. # 1

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.

Comment
There are no comments made yet.
Bruce Armstrong Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 16:22 PM UTC
  2. PowerBuilder
  3. # 2

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

 

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 08:31 AM UTC
  2. PowerBuilder
  3. # 3

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.

Comment
There are no comments made yet.
Amna Khalid Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 07:11 AM UTC
  2. PowerBuilder
  3. # 4

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?)

Comment
  1. Andreas Mykonios
  2. Friday, 27 September 2024 11:48 AM UTC
Needed on the client machines...
  1. Helpful
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 07:11 AM UTC
  2. PowerBuilder
  3. # 5

Do you have a certificate?

Comment
There are no comments made yet.
Amna Khalid Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 06:44 AM UTC
  2. PowerBuilder
  3. # 6

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

 

 

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 06:27 AM UTC
  2. PowerBuilder
  3. # 7

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.

Comment
There are no comments made yet.
Amna Khalid Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 06:21 AM UTC
  2. PowerBuilder
  3. # 8

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

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 27 September 2024 06:02 AM UTC
  2. PowerBuilder
  3. # 9

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.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.