which authentication mode is best in sql server 2008. RRS feed

  • Question

  • what is the differences between windows and mixed mode authentication. i am always confused about this question.
    • Moved by Tom Phillips Tuesday, August 14, 2012 7:29 PM Security question (From:SQL Server Database Engine)
    Tuesday, August 14, 2012 4:58 PM


All replies

  • 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.

    Tibor Karaszi, SQL Server MVP | web | blog

    Tuesday, August 14, 2012 5:02 PM
  • 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!

    Tuesday, August 14, 2012 7:14 PM
  • Books 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

    • Proposed as answer by amber zhang Wednesday, August 15, 2012 7:48 AM
    • Marked as answer by amber zhang Tuesday, August 21, 2012 3:52 AM
    Tuesday, August 14, 2012 9:49 PM