How to assign a DB user the sysadmin role?

Question

How can I assign a DB user the sysadmin role?

Answer

Step 1

Open the SQL Server Management Studio as administrator and connect to the correct instance (in this case myQA).

Step 2

Open the Security tree and right click on Login.

Step 3

Right click on the user you want to grant the sysadmin role - Properties.

Step 4

Select Server Roles (on the left) and tick sysadmin.

Step 5

Click OK to confirm the changes.