Join Adam Wilbert for an in-depth discussion in this video Implementing server-level security in SQL Server Management Studio, part of Database Fundamentals: Administration.
- View Offline
- Creating a new user login…and assigning them to a fixed server role…is accomplished through the new login window.…Right now, I'm logged in as assistant administrator…using the Windows Authentication login…that we established when installing SQL Server Express…back in the first course of this series.…In Management Studio, you can create a new login account…by going over here into the Object Explorer…and opening up the Security folder here.…Next, we're going to find the folder called Logins…and I'll expand that open…to see all the different login accounts…that are currently on this server.…In order to create a new one,…I'll right-click on the folder and choose New Login.…
I'm going to create a new login for Maria Sontas…and she's going to be established as a database creator.…In order to do that, we'll come over here…in the Login window here…and we will establish the Login name.…It's going to be "MariaSontas".…(keyboard typing)…And just as a reminder to myself…of what we are doing here, I'm going to put a hyphen…
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database