Connect to a MS SQL Server using Windows Authentication with a Java application

Question

Hello,

We are currently developing a Java application with Spring Boot that will be deployed on a Linux server. Our application must connect to an Microsoft SQL Server database and we are trying to use "Windows Authentication" as the authentication mechanism to connect to the database from our Java application.

We have tried different configurations in the JDBC connection URL, we also installed the library "mssql-jdbc_auth-<version>-<arch>.dll" but it didn't work either, we always get an authentication error.

The only way we can connect to the database is by using the "SQL Authentication" type.

Is it possible to connect to an Microsoft SQL Server database via a Java application with Spring Boot using the "Windows Authentication" type?

We really appreciate your help,
Thanks in advance

Answer 1

Hi RicardoRubio-6206,

Please refer to the following similar threads which might be helpful:
Connect to MSSQL from Spring boot application using windows authentication
java spring: configure properties for sql server with integrated authentication
And your issue is also related to Spring Boot. I suggest you open a thread in the corresponding forum so that people there will help you more effectively.

Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,
Thanks for the help, we tried following the suggested documentation, however it didn't work either.