Question - 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.