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
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