SQL Server security starts with logins. Learn how to create logins based on Windows or SQL Server accounts and manage those logins to secure your SQL Server instance.
- [Instructor] So while the server roles play…a crucial part in our security consideration,…they only determine certain permissions…on the database…and in order for them to be effective,…we have to apply them along with the concept…of the logins.…So let's take a look at the logins on our server.…If we expand the logins folder,…we'll see the current logins that are on the system.…We have a local Windows user account…for this current system.…We also have the local system administrator account…which is a SQL server login…and then we have various service accounts…that are configured.…
In order for us to secure the system…when we have users connecting to it,…we want to provide logins for those users…and in order to do so,…we simply right-click and choose new login.…On the login dialogue box,…we have the opportunity to specify…a Windows or SQL server authentication…type of user account.…If we're using Windows,…we can click search and go find a local Windows account…or if we're on a domain join machine,…a domain account.…
Author
Gerry O'Brien
Released
11/9/2016This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
- Installation and configuration considerations
- Data storage strategies
- Configuring database instances
- Performance considerations
- Security considerations
- Managing roles and users
- Managing data
- High-availability options
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 7s
-
-
1. Installation and Configuration
-
Database storage strategies2m 53s
-
Install SQL Server7m 32s
-
Setting up the database4m 5s
-
2. Database Instances
-
Configure linked servers5m 38s
-
3. Performance Considerations
-
Using the profiler5m 41s
-
Auditing the database7m 4s
-
Resource governor5m 16s
-
4. Security
-
Manage roles3m 52s
-
Manage server logins4m 53s
-
Manage database users3m 36s
-
Manage database roles2m 28s
-
Implement server permissions4m 22s
-
Logon triggers4m 17s
-
-
5. Managing Data
-
Backup demonstration5m 26s
-
Moving database files4m 41s
-
Ensure data integrity5m 43s
-
6. High Availability Options
-
Database replication9m 36s
-
Log shipping5m 54s
-
Database mirroring2m 16s
-
Always On2m 32s
-
-
Conclusion
-
Next steps53s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Manage server logins