title: Cannot login to SQL Server 2008, in Windows 7 x64
body: <p>Alright wasted hours and hours trying to get MSSQL Server 2008 to login via SQL Server Management Studio. It works fine in Windows XP computer, but in Windows 7 it does not work.</p>
  
  <p>Steps done:</p>
  
  <ol>
  <li>Install MSSQL, add logged-in administrator user in installation.</li>
  <li>type the correct hostname in the "login window" of SQL Server Management Studio.</li>
  <li>Error 18456 is returned with Windows authentication.</li>
  <li>SQL authentication, with username and password matching my windows account, does not work.</li>
  <li>Created a new user called it 'SQLServer', set the SQL account in 'Computer > manage > SQL Server > Properties' to 'use this account'. Restarted Service.</li>
  <li>Added SQLServer to Administrator group, and all the 'MSSQL' groups as well.</li>
  <li>Tried logging in with .\SQLServer and password that I set for SQL authentication method, no luck. </li>
  <li>Tried logging in with SQLServer and password, no luck either.</li>
  </ol>
  
  <p>I also tried installing "Service Pack 1 of SQL Server 2008", but no luck.</p>
  
  <p>Essentially, I cannot figure out how to login to my own local MSSQL server.</p>