Microsoft SQL Server 2014 Unleashed

Using SSMS to Manage Server Roles

You can find server roles in the Object Explorer under the Security node, which contains a Server Roles node. The Server Roles node lists both fixed and nonfixed server roles. To add a new custom server role (nonfixed), you right-click the Server Roles node and select New Server Role. A new Server Role dialog box appears, as shown in Figure 15.10.

FIGURE 15.10 The new Server Role dialog box.

You need to enter a name for the role and name for the owner of the role. In Figure 15.10 the new server role name has been set to DbCreatorOnly. A specific server instance has been selected as well, which causes the Permissions ...