Changing login roles for users and groups (Model Explorer)
You can use Model Explorer to set instance administrator login roles for users and groups.
To change a server login role:
1. Start Model Explorer.
2. In the left navigation pane, expand the SQL icon.
3. Right-click on a server that you want to change a server login in, point to Logins, then click Change Login Role....
4. In the Change Login dialog box, enter a user or a group name to change.
5. To change the server login role to an instance administrator, select the Admin check box.
Alternatively, to change the login to a standard user, clear the Admin check box.
6. Click OK to change the server login.
7. Confirm the ‘Changed login role successfully’ message appears, then click OK to finish.