Symptoms
I get the attached error when I try to load list views.
Logon failed for user 'NT AUTHORITYANONOMOUS LOGON'
Diagnoses
Checked the configuration of the service instance.
Resolution
= We were able to determine that the SQL Service instance was configured to use impersonation, the impersonated user does not have any permissions on the DB. We switched this to use the service account.
= The Service account also needed to be added permissions to the SQL DB, read write to the db
= We also changed the service instance to
== 'On different SQL Server' set to true
== 'Use Native SQL Execution' set false
Note that if you have 'On different SQL Server' set to true it is recommended to switch 'Use Native SQL Execution' set false as the SQL is not run locally
