Credentials - Domain Account

Question

Question

Mark Sharman · Sep 19, 2019

#Authentication #Business Service #SQL #Ensemble

Hi,

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?

Regards,

Mark

Discussion (2)2

Log in or sign up to continue

Scott Roth · Sep 19, 2019

Not sure if this will answer your question or not, but we had to move to the jTDS JDBC driver in order to pass an AD account through a connection.

jdbc:jtds:sqlserver://(server name/port) ;instance=tp;domain=osumc;useNTLMv2=true;cacheMetaData=true;prepareSQL=2;

1 0

score 0 · Answer 1 · 2020-12-07T16:33:36-05:00

In addition to Scott answer, I need to add one additional parameter:

databaseName=<database>;trustServerCertificate=true;domain=<domain>;useNTLMv2=true;cacheMetaData=true;prepareSQL=2

Thanks for the post Scott, it was very helpful!

Regards, Joel