SQL Server Database Administrator Question:
What authentication modes does SQL Server support?
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.
| Previous Question | Next Question |
| What are the steps to take to improve performance of a poor performing query? | What is blocking and how would you troubleshoot it? |