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

When changing the SQL Service instance on the SmartObject Tester to a different SQL Tenant the error below will be presented:

Image

Symptoms

It was discovered that the K2 Service account that is utilizing the SQL Service instance has insufficient permissions on the new SQL Tentant.

Troubleshooting Steps

To correct this add the needed permissions on the SQL Tentant like db_owner on the related database.