What are the Authentication Modes in SQL Server ?

221 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

Deleting Columns From a Table with a Query in MS SQL

What are the Different Recovery Models Inside SQL Server ?

What are the Limitations of Indexed Views in SQL Server ?

Adding Columns to a Table with a Query in MS SQL

What is the Merge Statement in SQL Server ?