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

How is Change Tracking is Different From Change Data Capture ?

What is Central Management in SQL Server ?

What is the Filtered Index in SQL Server ?

How to Restart SQL Server in Single-User Mode ?

MS SQL Get Current Time GETDATE()