Question: what is the difference between windows authentication mode and mixed mode?
Answer: Windows authentication mode requires users to provide a valid Windows username and password to access the database server. ... Mixed authentication mode allows the use of Windows credentials but supplements them with local SQL Server user accounts that the administrator may create and maintain within SQL Server.