I've a Service utilising the Adapter EnsLib.SQL.InboundAdapter, which uses a Credentials item set with the details of a local SQL account. This currently works, however, we're looking to use the credentials of an AD domain account.
The domain account is a member of an AD security group, which has the required permissions on the source SQL database. I've checked that access is possible with this account via SQL studio.
I've tested setting the Credential username as domain\username and username@FQDN, but neither create a successful connection.
Is there something simple i'm missing to be able to utilise domain credentials?