Microsoft SQL Server 2014 SP3 CU1
Lansweeper 7.0.151.4
SQL lives on a different server than Lansweeper. All permissions appear to be correct on the database and the user being utilized to scan has local administrator permissions on the endpoints.
All systems display this error: Column 'AssetID' does not belong to table
I was unable to find a thread with this specific error outside of an old lansweeper post: https://www.lansweeper.com/forum/yaf_postst2710_Column-nonactive-does-not-belong-to-table-theTable.aspx#post12727
I am using collation Latin_General_CI_AI and there are no issues with memory or CPU.
I believe this issue may have started to occur once the database was moved from SQLCompact to 2014. I followed the KB and have verified that all steps were taken.