Warning
Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support for assistance.
Issue
If TLS 1.0 is disabled on Microsoft Server 2016 you cannot connect to SQL Server 2016 database using Continuum database initialization.
Product Line
EcoStruxure Building Operation, Continuum
Environment
- Continuum Cyberstation
- Microsoft SQL Server 2016
- Microsoft Server 2016.
Cause
Microsoft no longer supports TLS 1.0 protocol and IT departments are disabling it. The current version of the ODBC driver (SQL Server) used with Continuum will not function correctly when TLS 1.0 is disabled on Windows Server 2016 in order to use TLS 1.2. A defect/hotifx QC#2290 has been issued for this issue.
Resolution
There is a hot fix for QC#2290 that needs to be applied to the cyberstation after the installation of the ODBC driver version 13. Use the following link to download the appropriate version of the ODBC driver for your version of the OS.
Link to download ODBC driver version 13
https://www.microsoft.com/en-us/download/details.aspx?id=50420
This hotfix fixes the following defect 2290 = When TLS 1.0 is disabled on server 2016 ODBC does not connect to SQL database. Hotfix is attached below.
Contact PSS for the hotfix for Cyberstation 2.03
Please note: The ODBC Driver 13 for SQL Server needs to be installed before the hotfix is applied
Deprecation date
Steps to apply this hotfix:
- Create a ContinuumDB backup
- Shutdown Continuum if it is running
- Make a backup of OmsInst.exe in the Continuum folder
- Extract the OmsInst.exe from the hotfix zip file and copy the new file to the Continuum folder
- Do an update/initialized database
- Start Continuum
