Data Engine: Invalid connection string attribute

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Data Engine is not connecting when TLS 1.2 is enabled and with SQL 2019 and throwing below errors:

 

Jun 18 22:54:00:776 [16316] 0 de: (1) Open [Microsoft SQL Server Native Client 11.0] Invalid connection string attribute

Jun 18 22:54:00:776 [16316] 0 de: (2) Open [Microsoft SQL Server Native Client 11.0] SSL Provider: The target principal name is incorrect.

Jun 18 22:54:00:776 [16316] 0 de: (3) Open [Microsoft SQL Server Native Client 11.0] Client unable to establish connection

Jun 18 22:54:00:776 [16316] 0 de: COM Error [0x80004005] Unspecified error - [Microsoft SQL Server Native Client 11.0] Invalid connection string attribute
Jun 18 22:54:00:776 [16316] 0 de: Unable to connect to database. so exiting

 

Environment

Release: Any UIM

TLS 1.2

DB: SQLServer 2019

 

Resolution

Try  adding TrustServerCertificate=True; to the connection string.

 https://stackoverflow.com/questions/37734311/mssql-with-ssl-the-target-principal-name-is-incorrect