title: c#.net connection string works with integrated security but not when specifying username and password
body: <p>I am new to sqlserver, I have a connection string as follows:</p>
  
  <p><code>&lt; add name="test" connectionString="server=dbServer\SQLEXPRESS;database=test;integrated security=SSPI;" /></code></p>
  
  <p>and the site connects and works fine.</p>
  
  <p>I created a user in SSMS 17.4, gave it a name</p>
  
  <p><code>&lt; add name="test" connectionString="server=dbServer\SQLEXPRESS;database=test;User Id=dbUser; Password=letmein;" /></code></p>
  
  <p>the site fails saying "login failed for user 'dbUser'"</p>
  
  <p>The user has following :</p>
  
  <p>server roles: public, dbcreator</p>
  
  <p>user mapping: 
      default schema: dbo<br>
      database role memberships: db_owner, public</p>
  
  <p>any idea why it fails on use of username/password?</p>
  
  <p>Thanks</p>