From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Authentication and user permissions - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Authentication and user permissions
- [Speaker] During the installation process for SQL Server we chose an option to enable something called Mixed Mode authentication. Which simply means that the server will accept both Windows and SQL Server login accounts. We can see this setting by right clicking on the server name here in the object explorer window and coming down to the very bottom and clicking on properties. There are lots of different server properties that we can configure here and they're split into different pages that you can see listed down the left hand side of the window. The one that we're interested in here can be found underneath the security page and its right here at the very top, SQL Server authentication. Here we can see that my server instance is currently set to the Mixed Mode authentication. It will accept both SQL Server and Windows authentication modes. The other option is to switch it in to only allow Windows authentication. This setting is great for testing and development of your database…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
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.