In this chapter, we will cover:
Listing SQL Server service accounts
Changing SQL Server service accounts
Listing authentication mode
Changing authentication mode
Listing SQL Server log errors
Listing failed login attempts
Enabling Common Criteria compliance
Listing logins, users, and database mappings
Listing login/user roles and permissions
Creating a user-defined server role
Creating a login
Assigning permissions and roles to a login
Creating a database user
Assigning permissions to a database user
Creating a database role
Fixing orphaned users
Creating a credential
Creating a proxy