Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set Spring Boot SqlServer

I can not connect Spring boot with SQL Server

spring.datasource.url=jdbc:sqlserver://192.168.134.92;databaseName=Attendance_Device
spring.datasource.username=emon
spring.datasource.password=1234
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
#spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2018Dialect
spring.jpa.hibernate.ddl-auto = false

Answer

I recommend check 3 things

1. Gradle or pom.xml dependency setting check.
   • Make sure dependencies of SQL set what you using
2. DB server firewall check
   • Check your server or router. Firewall could be block networking
3. DB server address or id/pw check
   • Check your DB infos