From the course: SQL Server 2022 Administration
Join today to access over 24,700 courses taught by industry experts.
Setup SQL Server security - SQL Server Tutorial
From the course: SQL Server 2022 Administration
Setup SQL Server security
So any time you set up a new SQL Server instance, you need to consider how you're going to set up the security for that instance. Now, there's an entire lesson on logins and database permissions and server permissions, but we're going to look at the high level configuration of a SQL Server instance and how you configure its security. So I'm going to right click on my SQL Server INSIDEOUT instance here and go back to properties. So I'm just going to go ahead and click the "Security" page. Now, this is broken up into a couple different sections. I'm going to go through each one of them here. At the very top, you have to select an authentication mode. This sets up how people can authenticate against your SQL Server. There are two authentication modes available. One is Windows authentication mode, which essentially means you have to be logged in two Windows with an account that SQL Server understands, which means it could be a local account, local on that machine, or it could be 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.
