Sqlism (8/7/2012)
Can a local system account(not AD account) pass windows authentication for logging into SQL Server?
If the account is on the same machine, yes.
If it's local system of a remote machine, nope. In this case you could authenticate the user with the machine account instead of the user account:
CREATE LOGIN [MyDomain\MyComputer$] FROM WINDOWS;
-- Gianluca Sartori