Manage Logins and Server Roles

Introduction

The Manage Logins and Server Roles module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

• Configuring Server Security
• Managing Access to the Server, SQL Server Instance and Databases

Exercise 1 - Configuring Server Security

In this exercise, you will perform the tasks required to manage logins and server roles.

Exercise 2 - Managing Access to the Server, SQL Server Instance, and Databases

In the task Configuring server security, you learnt to assign access to specific users on a server. If you have more than one instance running on a single physical server, you can use the same procedure to assign permissions for each of the instances.