SQL Server Security Basics | What is Authentication?

By definition Authentication means the process of verifying the identity of a user or process. If a user wants to talk to the database, SQL Server asks “Who you are?”, and authenticates you. There are three types of authentication modes available:

Windows Authentication

SQL Server Authentication

Azure Active Directory

Windows Authentication

This is the default authentication mode and the more secure as compared to SQL Server Authentication.