Statistica Document Management System (SDMS) database connection fails with "HRESULT: 80040510 Error description=[Timeout expired while waiting for system to finish initialization]
Article ID: KB0070208
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.5 |
Description
Statistica Document Management System (SDMS) database connection fails with the following error in the SDMS log file ([drive]:\Program files (x86)\Statistica\SDMS\Data\LogFiles\):
ERROR 2024-05-31 05:14:28.169 5344 An exception occurred in CSDMSSystem::OpenDatabase. HRESULT = 0x80040510 Description = [Timeout expired while waiting for 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]
Issue/Introduction
This article discusses Error 80040510 found in the SDMS Logfiles when requesting connection to SDMS database from Enterprise manager.
Environment
Windows and Windows Server 2016
Resolution
The error might be caused by patching the SQL server or any network-related system updates.
Verify the SQL server and protocol compatibility. These 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.
We generally observe the above-mentioned SDMS error when the TLS Protocol V1.0/V1.1 is disabled after patching the SQL Server.
1. Locate the TLS protocol in Internet Options with respect to the SQL Server compatibility and Enable it:
2. Restart the SQL Server.
Additional Information
Feedback
Yes
No
Powered by
