Symptoms

Smart Objects
 

Diagnoses

In the K2 SmartObject browser the one of the service objects can't be refreshed, meaning any changes made to the database e.g. new tables, aren't picked up. When refreshing the service instance (by right clicking on service object in the SmartObject brower > Service Object Explorer > SQL Server explorer > SQL Server explorer > SQL Server Instance and selecting Refresh Service Instance) an error message is give saying Login failed for user 'NT AUTHORITYANONYMOUS LOGIN'
 

Resolution

Instead of using impersonation here switch this to use the service account as the preferred authentication method.

Also the following permissions what added to the DB.

- DB Datareader
- DB DataWriter
- DB Owner