SQL Server Database Administrator Question:

Download Job Interview Questions and Answers PDF

What authentication modes does SQL Server support?

SQL Server DB Administrator Interview Question
SQL Server DB Administrator Interview Question

Answer:

SQL Server supports Windows Authentication and mixed-mode. Mixed-mode allows you to use both Windows Authentication and SQL Server Authentication to log into your SQL Server. It's important to note that if you use Windows Authentication, you will not be able to log in as sa.

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What are the steps to take to improve performance of a poor performing query?What is blocking and how would you troubleshoot it?