• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Windows could not connect to SQL Server after tls upgrade to tls 1.2

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

Resolved Windows could not connect to SQL Server after tls upgrade to tls 1.2

  1. Issue
0
Votes
Undo
  1. Minogue Susan
    Minogue Susan
  2. PowerBuilder
  3. Wednesday, 24 April 2024 12:26 PM UTC

We have windows based application developed on PowerBuilder 2017 and which connects to SQL server 2014. Recently, server protocol upgraded to tls 1.2. From then, application can not connect to database server and it throws SSL hand shake failed error. Please advise. 

  1. PowerBuilder
  2. TLS/SSL
  3. Windows OS
What triggers Accessibility Error
Datawindow syntax for setting the expression in tr...
Responses (4)
Arnd Schmidt
Arnd Schmidt Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2024 21:57 PM UTC
  2. PowerBuilder
  3. # 1

Hi Susan,

if you use ODBC, you will be fine if you install a newer ODBC Driver for SQL Server that supports TLS 1.2.

Eventually you have to set TrustServerCertificate in the ConnectionString, depending on the "quality" of your certificates.

hth

Arnd

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2024 18:25 PM UTC
  2. PowerBuilder
  3. # 2

As Roland and John said, upgrade PowerBuilder to PB 2022 R3 and use the MSOLEDBSQL driver if you want to use TLS 1.2.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2024 13:59 PM UTC
  2. PowerBuilder
  3. # 3

SQL Server 2014 support end date was Jul 9, 2019. PowerBuilder 2017 is also out of support. You should upgrade both.

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2024 13:44 PM UTC
  2. PowerBuilder
  3. # 4

I believe TLS 1.2 for SQL Server was not supported in PowerBuilder until version 2019 R3.

    https://docs.appeon.com/pb/whats_new/MS_SQL_Server_enhancements.html

Best regards, John

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.