JAVA - How to Connect spring boot application with SQL server 2016 (which has windows authentication)?

Question

I am using SQL server 2016.

and my application.property file is

spring.datasource.data-username=DDS-NA/njain

spring.datasource.data-password=

spring.datasource.url=jdbc:sqlserver://localhost;databaseName=photo-app

spring.jpa.hibernate.ddl-auto=update

spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect

I am getting "Cannot load driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver" error. could someone guide me?

Add the integratedSecurity=true to JDBC URL: jdbc:sqlserver://<<Server>>:<<Port>>;databasename=<<DatabaseName>>;integratedsecurity=true References in here spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect — huytmb
– huytmb, Commented Nov 24, 2018 at 14:44

Moddasir · Accepted Answer · 2019-07-29 15:11:52Z

1

Please download the drivers from here

Add the jar to your project Right Click on project - > Build Path -> Configure Build Path - > Libraries -> Add External JARs

And add the integratedSecurity=true to JDBC URL: jdbc:sqlserver://<<Server>>:<<Port>>;databasename=<<DatabaseName>>;integratedsecurity=true

You don't have to specify username and password for Windows Authentication

Moddasir

1,45913 silver badges34 bronze badges

answered Jul 29, 2019 at 13:51

Anish Kumar

1131 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1