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
If you want to connect to external database, couldn't you just provide domain name and password and authenticate with that?
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.
I'd start with setting the credentials in connection configuration. Should be enough.