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