title: How to connect my web application to SQL Server / SQL Server Express
body: <p>I am working with a web application that connects to a SQL Server database with this: </p>
  
  <pre><code>jdbc.url=jdbc:jtds:sqlserver://127.0.0.1/MyDatabase
  jdbc.username=sa
  jdbc.password=password
  </code></pre>
  
  <p>I am relatively new to SQL Server, however I have successfully accessed a <code>SQLEXPRESS</code> instance through the SQL Server Management Studio. </p>
  
  <p>I can see from the Security->Login folder there is a "sa" entry</p>
  
  <p>However when I run the web application I am getting this error:</p>
  
  <blockquote>
    <p>PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property
    'dataSource' threw exception; nested exception is
    org.apache.commons.dbcp.SQLNestedException: Cannot create
    PoolableConnectionFactory (Network error IOException: Connection
    refused: connect)</p>
  </blockquote>
  
  <p>I seems that the user: "sa" is not authenticated to access the database? </p>
  
  <p>If so, how can I use the SQL Server management studio to fix this? </p>