Online Documentation for SQL Manager for SQL server

Server Roles

The Server Roles manager allows you to browse the list of SQL Server roles, and to define login membership for each of the roles.

To launch the tool, select the Tools | Server Roles main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | Server Roles item from the context menu.

The upper list displays the server roles as a grid with the following columns: Server Role Name, Members Count.

Right-click an item within the list to call the context menu allowing you to refresh the list, or show/hide columns of the list. Using the context menu you can also export the list of server roles to any of supported output file formats.

Server roles management tools are also available through the Navigation bar of the Server Roles manager.

The lower area allows you to define login membership, i.e. to select the logins that will belong to the selected server role. The server roles determine the tasks that can be performed through the selected login.

To select a login, you need to move it from the Available Logins list to the Server Role Members list. Use the buttons or drag-and-drop operations to move the logins from one list to another.