What are the Authentication Modes in SQL Server ?

There are two authentication modes in SQL Server...

  • Windows Mode
  • Mixed Mode – SQL and Windows

To change authentication mode in SQL Server, go to Start -> Programs- > Microsoft SQL Server and click SQL Server Management Studio and under Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.



You May Interest

What is a Control Flow Inside SSIS ?

What is The Concept of Piecemeal Restore on SQL Server ?

What is The Difference Between The Index Seek and Index Scan in S ...

What are Replication and Database Mirroring in SQL Server ?

What is an OUTPUT Clause Inside SQL Server ?