>>My understanding was that "mixed mode" was when you were allowed to use both integrated/windows security *and* SQL Server auth.
>
>When you set up an SQL Server to run under "Windows Authentication", you are setting
>it to use "mixed mode" -- there's no way to disallow SQL Server logins (short of removing all
>defined logins, I guess.) So Trusted Connection is always Windows Authentication,
>but Windows Authentication is not always Trusted Connection. I could have written that
>more clearly.
I also could have written it the correct way. Where the heck has my brain been?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_6p9v.asp"Windows Authentication Mode
When a user connects through a Microsoft Windows® user account, SQL Server validates the account name and password using information in the Windows operating system.
Mixed Mode (Windows Authentication and SQL Server Authentication)
Allows users to connect using Windows Authentication or SQL Server Authentication. Users who connect through a Microsoft Windows user account can make use of trusted connections (connections validated by Windows) in either Windows Authentication Mode or Mixed Mode. SQL Server Authentication is provided for backward compatibility."