CODEWITHSUNDEEP
sql-serverdelphi
B.Geronatsios
B.Geronatsios

Reputation: 105

TLS 1.2 SQL Server and Delphi Client

I would like to connect to SQL Server TLS 1.2 via delphi XE7 application. How would be make the connection string ? It is possible ?

Upvotes: 0

Views: 2390

Answers (3)

B.Geronatsios
B.Geronatsios

Reputation: 105

According to microsoft Native SQL and SQLOLEDB is depricated and for a new development is OLEDB Driver : OLEDB Driver Microsoft

I just replace provider with MSOLEDBSQL.1 and works

Upvotes: 0

B.Geronatsios
B.Geronatsios

Reputation: 105

I play with Provider=SQLNCLI11.1 and not SQLOLEDB.1 . I made Encrypt=True and TrustServerCertificate=False and it works fine.

Upvotes: 0

fpiette
fpiette

Reputation: 12322

Within the application connection string, you just need to add the following parameters; Encrypt=True and TrustServerCertificate=False and that's it!

Of course your server must be configured to use TLS 1.2. And the client library you use must be TLS enabled.

Upvotes: 2

Related Questions