SQL Server Network Encryption

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are trying to enable TLS1.2 on our UIM DB (MS SQL 2014 standard). And we following steps from this KB to import Base64 CER self-signed, we keep having connection error in data_engine please advise:

from log:-

Native Client 11.0] SSL Provider: The target principal name is incorrect.

Jun 18 22:53:55:728 [9244] 0 de: COM Error [0x80004005] Unspecified error - [Microsoft SQL Server Native Client 11.0] Invalid connection string attribute
Jun 18 22:53:55:728 [9244] 0 de: Unable to connect to database. so exiting
Jun 18 22:53:55:728 [9244] 3 de: Database_global_lock LOCK
Jun 18 22:53:55:728 [9244] 3 de: Database_global_lock UNLOCK

Environment

UIM 20.4

Resolution

For Microsoft SQL Server versions that do not provide support for TLS v1.2 by default, follow the information in the article TLS 1.2 support for Microsoft SQL Server. By following the instructions in this article, you can download and apply the required packages depending on your Microsoft SQL Server version. For Microsoft SQL Server versions (for example, 2016) that support TLS v1.2 by default, you do not need to perform this manual process.