title: Unable to login to SQL Server + SQL Server Authentication + Error: 18456
body: <p>I have created login account on my localhost\sql2008 Server (Eg. User123)</p>
  
  <p>Mapped to Database (default)</p>
  
  <p>Authentication Mode on SQL Server is set to both (Windows and SQL)</p>
  
  <p>But login to SQL Server fails with following message (for User123)</p>
  
  <p>Note:  Have checked multiple time that UserName / Password are typed in correctly</p>
  
  <p>Error Details:</p>
  
  <blockquote>
    <p>Login failed for user 'User123'
    (Net.SqlClient Data Provider)</p>
    
    <p>Server Name : localhost\sql2008 Error
    Number: 18456 Severity : 14 State : 1
    Line Number : 65536</p>
  </blockquote>
  
  <p>any help on this please.</p>