Written by

Enterprise Application Development Consultant at The Ohio State University Wexner Medical Center
MOD
Question Scott Roth · Jun 7, 2018

JDBC Authentication to AD to access exteral database

Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain. 

I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain?

Thanks

Scott

Comments

Eduard Lebedyuk · Jun 7, 2018

If you  want to connect to external database, couldn't you just provide domain name and password and authenticate with that?

0
Scott Roth  Jun 7, 2018 to Eduard Lebedyuk

Haven't tried that. Wasn't sure if it was going to make me do the Authentication before I connect to the external database, or while connecting to the external database.

Maybe I am making a mountain out of a mole hill.

0
Eduard Lebedyuk  Jun 7, 2018 to Scott Roth

I'd start with setting the credentials in connection configuration. Should be enough.

0