From the course: Microsoft SQL Server 2016: Installation and Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage server logins - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Installation and Administration
Manage server logins
- [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…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.