[Backport release-3_40] [mssql] Fix resolving geometry types when invalid geometries present

[Backport release-3_40] [mssql] Fix resolving geometry types when invalid geometries present #27338