title: Connect to SQL Express with SSMS
body: <p>My machine Win7 has SQL Server 2005 and SQL Server 2008 installed.
  Also, Sql Server Management Studio is installed with SQL Server 2008.</p>
  
  <p>Now, I want to connect to SQLEXPRESS instance running currently on my machine.<br>
  How do I know if i will need Management Studio 2005 or 2008 to connect to SQLEXPRESS?</p>
  
  <p>Just to add that I have already tried connection with SSMS 2008, but it says  </p>
  
  <blockquote>
    <p>Can't connect to .\SQLEXPRESS, Login failed.</p>
  </blockquote>
  
  <p>One thing I just noticed is that under Windows Authentication,<br>
  User name is showing my user name with which I logged in to Windows.<br>
  But this machine used to belong to someone else and computer name has not changed to mine.<br>
  Could this be reason for login failure?</p>
  
  <p>Thank you!</p>