Modifying SQL Server administrators

If you do not designate a user as 'sysadmin' when you add their SQL Server login, you can so using the Modify SQL Server Administrators tab.

You also use the Modify SQL Server Administrators tab to remove the 'sysadmin' role for a user.

To change a user's 'sysadmin' role:

1. Click Company admins / SQL Logins > Modify SQL Server Administrators.
2. On the list of users:
   • Select the checkbox for each user you want to designate as an administrator for the SQL Server database.
   • Clear the checkbox for each user you want to demote to ordinary access to the database.
3. Click [Update sysadmins].