• 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