Model, Component, and Package Management > Model management > Model Explorer > Working with users and groups > Changing login roles for users and groups (Model Explorer)
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.
For more information, refer to Starting 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.