Issue
When executing any SQL Server Service SmartObject for a table in the target SQL database, the below error appears:
Error Code
Login for failed for user '<User Name>'
Symptoms
- Executing a SmartObject for a SQL stored procedure works fine.
- On the SQL Server service instance, the Authentication Mode is set to Static and the correct credentials are specified.
- The SQL server can be accessed using the same credentials specified in the SQL Server service instance.
- A UDL test to check connectivity from the K2 server to SQL server is successful.
Resolution
1. Edit the SQL Server Service Instance.
2. Under Service Keys, change the Use Native SQL Execution setting to False.
3. Click on OK to update the service instance.