title: SQL Server - Creating a new login account with "sysadmin" role from an account without "sysadmin" role
body: <p>My sql database has 2 accounts.</p>
  
  <p>1st account is <code>sa</code></p>
  
  <p>2nd account is <code>user</code></p>
  
  <p>Both account has <code>sysadmin</code> role enabled.</p>
  
  <p>We have already forgotten password for <code>sa</code></p>
  
  <p>We only know password for <code>user</code></p>
  
  <p>Somehow someone remove <code>sysadmin</code> role for <code>user</code>.</p>
  
  <p>Now I need an account with <code>sysadmin</code> role.</p>
  
  <p>How can I achieve that?</p>
  
  <p>I cannot change the password for <code>sa</code> as some websites might be using <code>sa</code> account to connect to the database.</p>
  
  <p>So, my best solution is to create a new account with <code>sysadmin</code> role by any means necessary.</p>