Problem. No data is collected...

[Simba]

Greetings!

I've set up Lansweeper server on Win2003Server+SQLServer2k. Client successfully connects to server, but then I have a bunch of

"(XXXX) Cannot insert the value NULL into column 'Lastchanged', table 'YYYY'; column does not allow nulls. INSERT fails."

errors in the server log file. Only "LOGON" table is updated, all other tables are empty. (where "XXXX" and "YYYY" - all category and table names)
I'm absolutely new to SQLServer, so I beg you to help me. I'm almost sure I've made some mistake in SQL configuration, but I cannot find it.

[Simba]

I've downloaded and applied new script. Everything seems to be working now. 🙂 Thanks guys!

[Hemoco]

I've uploaded a new lansweeper.zip file, please reapply the database script (now with defaults included)

[Hemoco]

Looks like the default value for the field "lastchanged" isn't filled in.
The default value should be getdate().

Can you check if you have a default value for this column?

I'll take a look if there are any errors in the sql script.