Sql Server Interview Question #13: What are the authentication modes in SQL Server? How can we change them?

This entry was posted in Sql Server tutorials and tagged authentication modes server sql on by .

Sql Server Interview Question:

What are the authentication modes in SQL Server? How can we change them?

Answer

Windows mode and Mixed Mode – SQL and Windows. To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Select the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.

 

Thanks for reading this article,

Next steps :

  1. Share this with your colleagues because Sharing is Learning
  2. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!