title: spring boot configuration with MS SQL Server 2016
body: <p>I am trying to connect to Microsoft SQL Server 2016 from spring boot application. SQL server is configured using <strong>windows authentication</strong>.</p>
  
  <p>Following are the configuration</p>
  
  <blockquote>
    <p>application.properties file</p>
  </blockquote>
  
  <pre><code>spring.datasource.url=jdbc:sqlserver://K877DTRV:1433;databaseName=testdb;integratedSecurity=true
  spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
  spring.datasource.initialize=true
  </code></pre>
  
  <blockquote>
    <p>pom.xml</p>
  </blockquote>
  
  <pre><code>&lt;dependency&gt;
  &lt;groupId&gt;com.microsoft.sqlserver&lt;/groupId&gt;
  &lt;artifactId&gt;mssql-jdbc&lt;/artifactId&gt;
  &lt;/dependency&gt;
  </code></pre>
  
  <p>java version is 1.8.spring boot version is 2.0.3.RELEASE</p>
  
  <p>I am getting the below error while starting the tomcat</p>
  
  <blockquote>
    <p>Cannot load driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver</p>
  </blockquote>
  
  <p>Should I do any additional configurations?</p>
  
  <p>Note: I am using Windows Authentication.</p>
  
  <p>Can anyone please help ?</p>