What Authentication Modes Does SQL Server Support?


Could someone please tell me what authentication modes does SQL Server support?



There are two types of authentication modes in the SQL server.

Windows authentication mode: The windows authentication mode uses the windows account and is responsible for connecting an instance of SQL server through a windows NT or windows user account.
Mixed authentication mode: The mixed authentication mode uses either Windows or SQL server and is responsible for connecting an instance of Sql server by either using the sql server authentication or the windows authentication.


If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.


This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.