We observe the below-mentioned error in Enterprise Manager when attempting to connect to the SDMS Server:


SDMS logs show the error :

ERROR 2024-05-31 05:14:28.169 5344 An exception occurred in CSDMSSystem::OpenDatabase. HRESULT = 0x80040510 Description = [Timeout expired while waiting for the system to finish initialization]
ERROR 2024-05-31 05:14:42.79 12776 Cannot connect to the database: Database errors: HRESULT: 0x80004005. ADO Errors: ADO Error description=[[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.] NativeError=[18] ErrorNumber=[-2147467259] SQLState=[08001]

This SDMS error can be observed due to the TLS Protocol V1.0/V1.1 being disabled.

There could be multiple reasons behind TLS gets disabled, like patching the SQL Server where SDMS is hosted.  It is advisable to review the SQL server and the PROTOCOL compatibility, SQL Server 2016, SQL Server 2017 on Windows, and SQL Server 2019 on Windows versions ship with TLS 1.0 to TLS 1.2 support. You have to disable TLS 1.0 and 1.1 if you want to use only TLS 1.2 for client-server communication.

For compatibility of TLS with SQL Server versions see here: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-1-2-support-microsoft-sql-server

Simply enabling the TLS Protocol V1.0 and V1.1 with SQL Server restarts can fix this issue.