14 august 2012 16:58what is the differences between windows and mixed mode authentication. i am always confused about this question.
- Mutat de Tom Phillips 14 august 2012 19:29 Security question (From:SQL Server Database Engine)
14 august 2012 17:02
In Windows mode, you can only login through your Windows account. You cannot login using SQL Server logins (passing login name and password), such as "sa".
I prefer to run in Windows Only mode, but in reality it is rare to not have some appfor which I have to use SQL Server logins, for one reason or another.
14 august 2012 19:14
SQL server support SQL & windows two authentication types. Windows authentication mode supports only windows authentication and Mixed mode support both SQL & windows authentication.
It always good to use windows authentication mode because Windows Authentication is trusted as username and password are checked with the Active Directory, the SQL Server authentication is untrusted as it handle by SQL Server.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
14 august 2012 21:49Books Online guidance Choose an Authentication Mode http://msdn.microsoft.com/en-us/library/ms144284.aspx
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty