In SQL Server, are 2 types of Authentication
models.
- Windows authentication
- SQL Server authentication
Windows Authentication:-
- In the Windows authentication model, we play the role of Database Admin.
- User Name and Password is created by Windows OS by default, so it is the default authentication model.
- So, here we don't need User Name and Password to enter for login.
SQL
Server Authentication:-
- We play the role of a User.
- User Name and Password is created by the Database Administrator.
- We need to enter User Name and Password for login.
