Following are the advantages of using SQL Server AUTHENTICATION:-

• It enables SQL Server to work with older APPLICATIONS and third-party apps that require SQL Server authentication.
• It enables SQL Server to work in mixed-OS situations where all users are not authenticated through a Windows domain.
• It enables users to connect from domains that are unknown or UNTRUSTED. For example, an application that allows established clients to check the progress of their orders using assigned SQL Server logins.
• It enables SQL Server to support user-created identities in Web-based applications.
• It enables software developers to deploy their programs utilising a complicated permission hierarchy based on SQL Server logins that are known and pre-configured.

Following are the disadvantages of using SQL Server Authentication:-

• Even a Windows domain user with a Windows login and password must provide another user id and password (SQL Server) to connect. Many people find it challenging to keep track of several user IDS and passwords. It can be inconvenient to have to supply SQL Server credentials each time you connect to the database.
• The Kerberos security protocol is not supported by SQL Server authentication.
• Additional password policies are provided for Windows logins that are not accessible for SQL Server logins.
• At the moment of the connection, the encrypted SQL Server Authentication login id and password must be sent over the network. The password is stored on the client by some applications which connect automatically. These are attack spots that are susceptible to ATTACKERS.