How to make a user a SQL sysadmin

  1. In Microsoft SQL Server Management Studio, expand Security, then expand Logins.
  2. Right-click on Logins and select New Login. If your user already has a login listed here, go to the Properties of this user.
  3. Click on Server Roles.
  4. Check sysadmin so that it is ticked.
  5. Click OK.

Was this article helpful?

Have more questions or facing an issue?
Submit a ticket