Post reply

Local System accounts

  • August 7, 2012 at 5:34 pm

    #265561

    Can a local system account(not AD account) pass windows authentication for logging into SQL Server?

  • August 7, 2012 at 8:30 pm

    #1522935

    If when installing the SQL Server you left the "Built in administrators" group enabled (or enabled it at another time) , it will

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • August 8, 2012 at 2:13 am

    #1522995

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply