EBO 6.0 - External Log Storage MSSQL: Invalid object name 'nsp.nspschemachangelog'

[Miguelillo]

Hello,

We are setting up External Log Storage with Microsoft SQL Server on an
Enterprise Server running EBO 6.0.4.90.

Current setup:

• SQL Server Express installed on a separate machine on the same network
• Database created, SQL login created (db_owner on that database)
• Mixed mode authentication enabled, TCP/IP enabled on port 1433
• Firewall rule allowing the ES to reach the SQL server
• Connectivity verified from the ES with Test-NetConnection (TcpTestSucceeded: True)
• In WorkStation: System > External Log Storage > Microsoft SQL Server

configured with the IP address only (no instance name), port 1433,
SQL user, SSL mode Disable, Trend storage enabled = True

EBO reaches the database, but Storage Info shows Trend storage available =
False and the following system alarm is raised:

42000: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name
'nsp.nspschemachangelog'. [Microsoft][ODBC SQL Server Driver][SQL Server]
Statement(s) could not be prepared.
System alarm ID: External storage unavailable

We understand the database must first be initialized with the "External Log
Storage - MSSQL Installation Script", which creates the nsp schema. The
knowledge base article "Setup External Log Storage using MSSQL" states this
script is available on the EcoXpert web page, which we cannot access as an
end customer.

Could you advise how an end customer can obtain the MSSQL installation
script for EBO 6.0?

Thank you.

[CraigEl]

@Miguelillo EBO Software is only available to approved Schneider Electric EcoXperts. You will need to contact your system installer or maintainer.