Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Connecting to MS SQL Database using JDBC and Service Account

Question
Scott Roth · Aug 8, 2018

Connecting to MS SQL Database using JDBC and Service Account

We have a new requirement being push down by our Data Security to no longer use Local SQL Accounts to access our Databases. So they asked me to create a Service Account that is on the Domain for our connections to each database.

I tried just changing my JDBC connection to using this Service Account and Password but I am not having any luck trying to connect to the database.

" Connection failed.
Login failed for user 'osumc\CPD.Intr.Service'. ClientConnectionId:ade97239-c1c8-4ed1-8230-d274edb2e731 "

In reading some of the material about using a Domain Service Account it mentions having kerberos installed. Is this needed for Ensemble JDBC connection to a Microsoft SQL Database to work using a Domain Service Account?

Does anyone use JDBC connections to connect to non cache databases using a Domain Service Account? If so how was this accomplished?

Thanks

Scott

#Databases #JDBC #Security #SQL #Ensemble

Source URL:https://community.intersystems.com/post/connecting-ms-sql-database-using-jdbc-and-service-account