title: Unable to log in to server in SQL Server 2008 R2 Management Studio
body: <p>I have a SQL Server 2008 R2 instance and can log in using the <code>sa</code> user. But I want to define another user (<code>administrator</code>) to log in with SQL Server Management Studio, so I did the following:</p>
  
  <ul>
  <li>Logged in to the server in Management Studio as <code>sa</code>.</li>
  <li>Right clicked on the database name.</li>
  <li>Clicked on properties.</li>
  <li>Then under permission, I select the required username (<code>administrator</code>).</li>
  <li>And I grant him all the permission.</li>
  </ul>
  
  <p>But when I tried to log in using <code>administrator</code>, I got the following error:</p>
  
  <blockquote>
    <p>Login failed for user “administator” Error 18456.</p>
  </blockquote>
  
  <p>Can anyone advise what might be the problem?</p>