Join Gerry O'Brien for an in-depth discussion in this video Understanding SQL Server authentication modes, part of Securing SQL Server 2012.
SQL Server offers two authentication modes during setup.…These can also be changed on an installed instance, if desired.…Understanding each authentication mode, and how to configure the options,…is an important aspect to any SQL Server security topic.…During the setup portion of SQL Server, you're given the…option to choose which authentication mode you wish to use.…Note that you can also select mix mode, in which case SQL Server supports…SQL authentication and Windows authentication.…Also selecting the mix mode option means that you must supply…a password for the system administrative account on your SQL Server instance.…
As we indicated, after you've installed SQL…Server, you can change the authentication mode by…selecting the server, right-clicking, and choosing Properties,…and going to the Security page, and changing…your server authentication mode from here.…Note that this particular instance is installed in mix-mode authentication.…Also note that changing the authentication mode for SQL Server after the…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network