SQL SmartObjects are not executing resulting in the error "User does not have permission to perform this action"
kbt143603
PRODUCTK2 Five
K2 blackpearl
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
SQL server service instance list method shows error "User does not have permission to perform this action."Symptoms
When using a combination of SQL Service Instance's Authentication Mode and the Service Keys 'Use Native SQL Execution' and 'On Different SQL Server' will result in different behaviors, see link below.
Troubleshooting the SQL Server Service Type
