Issue
Getting the connection error below when using Microsoft SQL server as External Log Storage for EBO.
Error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
SSL Security error
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen (SECDoClientHandshake()).
[Microsoft][ODBC Driver Manage
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Enterprise Server (ES)
- Building Operation Enterprise Central (EC)
Cause
When EBO connects to the Microsoft SQL server it uses the ODBC installed on the computer.
It will use the ODBC version which comes with the OS and not the newest one installed on the computer.
In this case that was too old to work with the Microsoft SQL server
Resolution
It is possible to specify what ODBC version EBO should use.
- First check what ODBC version is installed on the computer.
- Enter ODBC in the search bar on the computer
- Open ODBC Data sources and select the Drivers tab.
- Enter ODBC in the search bar on the computer
- Open EBO and navigate to the properties /External Log Storage/Microsoft SQL Server in the system tree.
- In the Database name field it is possible to specify which ODBC version EBO should use, see picture below