This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

After creating a service instance to connect to an SQL database with authentication mode "Impersonate", the users who are trying to access a List View based on the SQL SmartObject receive the following error:

Image

Symptoms

This issue occurs because the 'K2 Service Account' does not have the rights to impersonate as a user which is why the error appears.

Troubleshooting Steps

To resolve this issue:

- Open SQL Server Management.

- Grant Impersonate Any Login to the K2 Service account as below:

Image

- Add individual user Logins (i.e.DENALLIX\Codi) to Security > Logins.

These modifications will allow the users to access the list view based on the SQL SmartObject.