Authentication Modes in SQL Server

There are two authentication methods.

1) Windows authentication
2) Sql authentication

windows authentication takes current logged in windows credentials.
Sql server authentication takes the user id and password created on the sql server.

Hi Manish,


Please refer the below link

http://technico.qnownow.com/2012/03/17/explanation-of-different-sql-server-authentication-modes/

Thanks

Hi Manish,

For Authentication Modes Click Here

To know about how to change Authentication Mode Click Here