spring boot sql server 2008 connection

first add the dependence in pom.xml file

<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<scope>runtime</scope>
</dependency>

then we can add the below mention configuration in application.property file

spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url =jdbc:sqlserver://localhost:1433;databaseName=pos
spring.datasource.username = sa
spring.datasource.password = sa

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.SQLServer2008Dialect

then check the MS-SQL syntax for entity creation.