[Windows] NetXMS Core won't start

[Manuel Schneider]

Hi,

I just installed a fresh Microsoft SQL Express 2017 Server, created the database "NetXMS" and a correspondign user "NetXMS". Then I installed the NetXMS Server Core (Version 2.2.1) and run the Server Configuration Wizard, which finished succesfully.

After that I tried to start the "NetXMS Core" Service, which failed.
In the Logs I can see a failed SQL-Query "SELECT snmp_oid,description,flags FROM snmp_trap_pmap WHERE trap_id=? ORDER BY parameter"...
...when I execute this Query against the Database through the SQL Server Management Studio (logged in as user "NetXMS"), I get the following error:

Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von "?".

Translation: Wrong Systax near "?"

I did the installation on a freshly installed Windows 10 PC (Drivers are up-to-date, Windows Updates are installed).

I've got no idea whats going wrong in my setup...
...any ideas?

Best regards,
Manuel Schneider

[victor]

Hi,

please enable logging to file (by setting LogFile = some_file in netxmsd.conf), set debug level to 9 (by setting DebugLevel = 9 in netxmsd.conf), try to start service, and post log file here.

Best regards,
Victor