What are all the different authentication techniques used to connect to MS SQL Server?

Answer

SQL Server should authenticate before performing any activity in the database. There are two
types of authentication:
Windows Authentication – Use authentication using Windows domain accounts only.
SQL Server and Windows Authentication Mode – Authentication provided with the
combination of both Windows and SQL Server Authentication.