Question

What setting should be used when configuring an on prem server in particular the Use Native SQL Execution setting?

Answer

Depending on whether or not you are utilizing an on prem installation for your SQL server will decide exactly what value you will use in relation to the Use Native SQL Execution setting. For example if you are utilizing an on prem SQL server you will need to make sure this value is set to True. If you are configuring the service instance and try to complete the action you may find that an error occurs this is most likely the reason this is occurring.