Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Local System accounts Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 5:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:46 PM
Points: 235, Visits: 981
Can a local system account(not AD account) pass windows authentication for logging into SQL Server?
Post #1341624
Posted Tuesday, August 7, 2012 8:30 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:31 AM
Points: 3,900, Visits: 7,138
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; They'll drag you down to their level and beat you with experience"
Post #1341654
Posted Wednesday, August 8, 2012 2:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:18 AM
Points: 5,018, Visits: 10,535
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1341723
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse