We upgraded from version Sitecore 9.0 to Sitecore 10 the sql version is 2016 SP1 and 10 is working but with search problem, sitecore Index Manager is empty. Is this because of sql version? So, we were going to install a new instance using the Graphical Installation but it errors out with:
More Information: Could not deploy package.
Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql140DatabaseSchemaProvider is not valid.
Is this because the SQL server is running 2016 SP1?