title: Can't connect to local database with user and pass credentials
body: <p>I'm trying to connect to a local SQL Server database but it gives me this error:</p>
  
  <blockquote>
    <p>Login failed for user 'DOMAIN\Username'.</p>
  </blockquote>
  
  <p>When I open SQL server and look in the <code>Security\Logins</code> folder then I do see the user <code>DOMAIN\Username</code>. This is also the user that I use to login into Windows with.</p>
  
  <p>My connection string looks like this:</p>
  
  <pre><code>&lt;add name="ServerConfiguration"
         connectionString="server=localhost; database=BN_Configuration; 
         Integrated Security=false; User ID=DOMAIN\Username; Password=123456;" 
         providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>Anyone any idea why I can't login with these credentials?</p>
  
  <p>--</p>
  
  <p><strong>Note</strong> I wish to authenticate with a user that exists in the SQL Server database. So I do  NOT want to do Windows authentication with <code>Integrated Security</code> set to <code>false</code>.</p>