we have enable a SQL service object impersonate (Enfore impersonation) . This is giving a strane behaviour Some time this is loading the data in k2 form and some time this is not loading the data.
Any idea what could be the reson?
Perhaps enabling Hostserver logging (https://help.k2.com/kb000298) might provide some additional information. As test if you update/create a new SQL service instance and use Service account as the authentication type, then do you get the same issue?