How to remove a login from a fixed server role (Enterprise Manager)

SQL Server Setup Help

SQL Server Setup Help

How to remove a login from a fixed server role (Enterprise Manager)

To remove a login from a fixed server role

  1. Expand a server group, and then expand a server.

  2. Expand Security, and then click Server Roles.

  3. In the details pane, right-click the server role to modify, and then click Properties.

  4. On the General tab, select the login to remove, and then click Remove.

See Also

Viewing and Modifying Role Memberships