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

There are no properties are listed under a SQL Stored Procedure ServiceObject.

Symptoms

The stored procedure references a table from a different SQL server instance. On Different SQL Server and Use Native SQL Execution are both set to true on the SQL Service Instance.

Troubleshooting Steps

If On Different SQL Server and Use Native SQL Execution are set to true, the sp_addlinkedserver must be executed by the K2 service account. Kindly refer to the documentation for more details.