Question: what is the difference between windows authentication and sql server authentication?
Answer: SQL Server authentication uses user accounts that are created and stored within the SQL Server instance, (and are thus specific to individual SQL Server installations), whereas Windows authentication is based on Windows user accounts[1] .