How to use a SQL Database in the context of the SQL user with Smartobjects in K2

Check the role membership for your static account on databases where it needs access. K2 will always respect the external data source’s security settings based on the authentication method used. Any account that you use when configuring the SQL Server Service Instance for your database(s) needs to have db_datareader in all the databases you want to use so that it can query the schema and data. If you want to write and update data, then it should also have db_datawriter too.

Hello JRoberts,

that worked so far, but I still got an error message, when I try to read all the items in the table.

What could that cause? Creating, Updating, and Reading one item works.

Best regards

Matthias

Try refreshing the Service Instance in the Management site and see what happens there. Can you post the error message here too?

Try refreshing the Service Instance in the Management site and see what happens there. You could also regenerate the SmartObjects after that.

Can you post the error message here too?

Hello JRoberts,

sure. I tried to refresh it, but i won’t work. I give the rights to the account you remcommended me. That’s work, but not for the “List” method.

Here is the error message:

I really don’t know which permissions are missing.

Best regards

Matthias

I have a demo system that connects to SQL with a static connection with the following settings in the service instance. Wondering what the marked settings below are in your environment? I have these authentication and impersonation settings set to false. I can ask around internally for some other things to check too. Could you be trying to connect to SQL with the K2 server service account? Trying giving that the same permissions as a test.

Check this out too: