title: SQL Server 2008, recovering my password / login to management studio?
body: <p>On Windows 7 machine which I acquired, another user had previously installed SQL Server 2008 on to it under their user name.</p>
  
  <p>Now, from my account when I try to start the Management Studio, I can NOT seem to connect to my local Server. I have tried:</p>
  
  <p><code>(local)</code> and <code>CName\InstanceName</code>
  both with the <code>Windows Authentication</code> and  <code>SQL Server Authentication</code> (I tried "sa" and "sa" for SQL server authentication)</p>
  
  <p>I keep getting the same error:</p>
  
  <p><code>Login failed for user 'foo', (Microsoft SQL Server, Error: 18456)</code></p>
  
  <p>Is there a way I can add new account with out logging in?</p>
  
  <p>Or, do I have to uninstall and reinstall the whole darn thing?</p>