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 the below video demonstrating 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.
Also please note the following:
- In the video the "Host address" in EBO is set to the IP address or DNS name\SQLserver instance like this: localhost\SQLEXPRESS. 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 address".
- The video demonstrates using the version 5 script when configuring the database in the MSSQL server, search External Log Storage - MSSQL Installation Script to download the appropriate EBO version script.
- For the example query to manage user permissions download User Rights Script or see attached script.txt.
- If using MSSQL Express rather than the full MSSQL version it may be necessary to consult External log storage not working with SQL Server Express.
