What are the Authentication Modes in SQL Server ?

19 Reads Ms Sql

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.

Ms Sql

You May Interest

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

What is Change Data Capture in SQL Server ?

Disable All Triggers in MS SQL Server Table

What is NOLOCK Hint in SQL Server ?

Getting List of System Hard Disks with Free Space in MS SQL Serve ...