title: SQL Server: single usermode
body: <p>I had an issue with SQL sysadmin accounts and SA disabled.</p>
  
  <p>I wanted to recreate the sysadmin account using single user mode. </p>
  
  <p><code>-m'SQLCMD'</code> activated the single usermode on one of the SQL Server instances service (one of the named instance).</p>
  
  <p>The problem is, when I am trying to log on sqlcmd, I am get the error message:</p>
  
  <blockquote>
    <p><code>Login failed</code>, Server is in single usermode only one administrator can connect at this time.</p>
  </blockquote>
  
  <p>I stopped all the services, leaving only me logged on. Disabled even tcp, but still I get the same error.</p>
  
  <p>How do I find out if any account is trying to log on, or am I doing something wrong?</p>