Question

How do I add a Windows account as an MSSQL admin?

 

Answer

  1. Open MSSQL Management Studio
  2. Log in to the database server
  3. In Object Explorer, expand the entry for your server
  4. Expand "Security"
  5. Right-click "Logins" and select "New Login"
  6. On the "General" page, select "Windows Authentication" and use the "Search" button to find the desired Windows user account
  7. On the "Server Roles" page, check both "public" and "sysadmin"
  8. Click "OK"