How do I fix Evolve 2.2 Windows Authentication not working? (4284212)

Error Message:

ERROR: System.Data.SqlClient.SqlException (0x80131904): SELECT failed because the following SET options have incorrect settings: 'NUMERIC_ROUNDABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Symptoms:

Error appears when you turned on Windows Authentication in the log file for Evolve2.2.

Resolution:

To resolve this issue please turn of the “Numeric_Roundabort” in the SQL database options.