title: Microsoft SQL JDBC Spring boot configuration does not work when database name is not in the url
body: <p>I have a spring boot JDBC <strong>Cofiguration A</strong> as below which works well,</p>
  
  <p><strong>Configuration A</strong></p>
  
  <pre><code>spring.datasource.sqlserver.url=jdbc:sqlserver://localhost:1433;database=my-testdb
  spring.datasource.sqlserver.user=user_101@server-product1
  spring.datasource.sqlserver.password=password_101    
  spring.datasource.sqlserver.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
  </code></pre>
  
  <p><strong>Configuration B</strong> below does not. Note that the url string does not have the database name in it. The database name is specified in a separate line, as one would expect to configure.</p>
  
  <pre><code>spring.datasource.sqlserver.url=jdbc:sqlserver://localhost:1433
  spring.datasource.sqlserver.user=user_101@server-product1
  spring.datasource.sqlserver.password=password_101
  spring.datasource.sqlserver.database=my-testdb 
  spring.datasource.sqlserver.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
  </code></pre>
  
  <p>Cannot figure out why the database name cannot be specified in a separate line and has to be in the URL. Can anyone mention why this does not work?</p>
  
  <p>Other configuration : Spring Boot, sqljdbc41.jar</p>