Issue
How to setup and configure External Log Storage in EcoStruxure Building Operation (EBO) when using Microsoft SQL Server as external log storage.
Product Line
EcoStruxure Building Operation
Environment
- Building Operation Automation Server Premium (AS-P)
- Building Operation Enterprise Server
- Building Operation Enterprise Central
Cause
You use External Log Storage feature to store historical data from EcoStruxure BMS. The amount of stored data is limited only by the equipment you use, and not by the capacities of the feature.
The External Log Storage feature uses an external database administered by either a combination of TimescaleDB and PostgreSQL software, or Microsoft SQL server.
Resolution
Please see video which will show how to:
- Create a database and user account in Microsoft SQL (MSSQL) Server using Microsoft Server Management Studio.
- Configure the External Log storage connection between EBO and MSSQL server in EBO.
In the video the "Host address" in EBO is set to IP address or DNS name\SQLserver instance like this: localhost\SQLEXPRESS
But if the SQL server is not located on the same computer as the EBO server only use the IP address or DNS name and no instance on "Host adress".
The script used when creating the database in the MSSQL server can be found here:
External Log Storage - MSSQL Installation Script v5.0 - EcoStruxure Building
The script used when adding the user to the database and give the user the correct rights level is attached to this Knowledge Base article.
