title: Cannot Add a Sql Server Login
body: <p>When I try to create a SQL Server Login by saying</p>
  
  <pre><code>CREATE LOGIN [ourdomain\SQLAccessGroup] FROM WINDOWS;
  </code></pre>
  
  <p>I get this error</p>
  
  <blockquote>
    <p>The server principal 'ourdomain\SQLAccessGroup' already exists.</p>
  </blockquote>
  
  <p>However, when I try this code</p>
  
  <pre><code>DROP LOGIN [ourdomain\SQLAccessGroup]
  </code></pre>
  
  <p>I get this error</p>
  
  <blockquote>
    <p>Cannot drop the login 'ourdomain\SQLAccessGroup', because it does not exist or you do not have permission.</p>
  </blockquote>
  
  <p>The user that I am executing this code as is a sysadmin.  Additionally, the user <code>ourdomain\SQLAccessGroup</code> does not show up in this query</p>
  
  <pre><code>select * from sys.server_principals
  </code></pre>
  
  <p>Does anyone have any ideas?</p>