I’m trying to test BigFix Insights in our lab which is running BigFix v10 and MSSQL 2016. I see in the Insights documentation that it says MSSQL2017 is required (which is very specific and it would be nice if that was open to other versions). But just testing, I went into v10 WebUI > Settings > Insights and tried to create an instance and I get this error:
Error on BigFix Insights connection
Error: Error: Incorrect syntax near 'TEMPORAL_HISTORY_RETENTION'.
Besides redeploying to MSSQL 2017 is there anything that can be done (even if it is unsupported)?