Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved SQL Server connectivity and TLS 1.3

  1. Issue
0
Votes
Undo
  1. Panos Platanas
    Panos Platanas
  2. PowerBuilder
  3. Wednesday, 7 September 2022 13:20 PM UTC

Hi,

our PB 2017 application cannot connect to SQL Server database via SNC when the machine's TLS is 1.3.

We recompiled the application using PB 2021 and it still cannot connect.

What changes are required in order for a PB application to work/connect on SQL Server while the PC is on TLS 1.3?

Thank you

  1. PowerBuilder (Appeon)
  2. SQL Server
  3. TLS/SSL
Problem Encountered while using LoadWithDotNetFram...
Alternative Language to migrate from PB
Responses (4)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 7 September 2022 20:04 PM UTC
  2. PowerBuilder
  3. # 1

I did a search and found this:

https://docs.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8-and-tls-1-3?view=sql-server-ver16

It appears that TLS 1.3 is supported in SQL Server 2022. You should contact your DBA or Microsoft SQL Server support to verify.

Comment
John Fauss
  1. John Fauss
  2. Wednesday, 7 September 2022 20:40 PM UTC
Nice, Roland! From looking at the PB 2022 documentation of the Encrypt DBParm setting, there currently is no way to specify the "strict" option for encryption, so it looks like an enhancement will be needed in PB in order to support TLS 1.3 in a SQL Server database connection with the MSOLEDBSQL 19.0 native interface.. Hopefully. it will be available in the near future.
  1. Helpful 1
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 7 September 2022 16:35 PM UTC
  2. PowerBuilder
  3. # 2

I am not sure that SQL Server itself supports TLS 1.3 yet.  When Googling I didn't really find mention of this being supported.  So I would suggest contracting Microsoft to verify which version of SQL Server supports TLS 1.3.  Assuming it is supported, as Andreas and Roland mentioned you will need to upgrade to PB 2022 and use MSOLEDBSQL interface so you are on the latest version of the driver.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 7 September 2022 16:23 PM UTC
  2. PowerBuilder
  3. # 3

Try MSOLEDBSQL with PB 2022 which was just released.

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Wednesday, 7 September 2022 13:34 PM UTC
  2. PowerBuilder
  3. # 4

Hi.

What I can say is that in 2019 R3 support for TLS 1.2 was added for MSOLEDBSQL and SNC SQL Native Client interface (Microsoft SQL Server enhancements - - What's New (appeon.com)). After that I have not heard about any other improvement. So I guess TLS 1.3 may be unsupported at this moment. You may open a support case, and if the answer is that it's not currently supported, ask for an enhancement.

Andreas.

Comment
Panos Platanas
  1. Panos Platanas
  2. Wednesday, 7 September 2022 13:37 PM UTC
Thank you very much Ανδρεα
  1. Helpful
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.