title: Connect to MS SQL Server on Spring Boot Application
body: <p>I have been trying to connect to MS SQL Server from my Spring Boot Application but I have not been able to manage it yet.</p>
  <p>Application.properties</p>
  <pre><code>server.port=8080
  spring.datasource.driverClassName = com.microsoft.sqlserver.jdbc.SQLServerDriver
  spring.datasource.url=jdbc:sqlserver://sqlsrv\\DESKTOP-ND9850L;databaseName=benjamin
  spring.datasource.username=benjamin
  spring.datasource.password=pass1234
  </code></pre>
  <p>Error Code.</p>
  <blockquote>
  <p>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host sqlsrv, named instance desktop-nd9850l failed. Error: &quot;java.net.UnknownHostException: sqlsrv&quot;. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.</p>
  </blockquote>