"The Microsoft SQL Server 2016 Database Encountered An Error While Running This Query" Error While Accessing Insights

Why is it not possible to view data in the newly installed / upgraded 2021.10 version of Insights?

Post a successful installation / upgrade of v2021.10 of Insights, sometimes the below error is thrown while trying to view data in Insights.


This error essentially occurs when SQL server 2016 is leveraged, as opposed to version 2019 which Insights 2021.10 is compatible with. This is mentioned in the "Database requirements" in the Insights official docs.

A similar error message is also thrown, with any lower versions of the SQL server.

To resolve this: