Hello All, 

I am new to K2 and I have a question in regards to setting up service instances for SQL Server.

My client has a requirement that we connect to SQL server for this particular application using an application specific service account - not the K2 service account.

All the service accounts exist in Active Directory.

Is it possible to setup a SQL Service instance with the application specific service account?

I have tried using SSO without much luck - I am getting the following error: "Validation login failed for user 'xxx'".

The service account has been granted access to the database.

I am looking for some general guidance on how to satisfy this requirement so any suggestions would be greatly appreciated.

Thanks!