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, May 21, 2015 3:53 PM
Points: 258, Visits: 1,105
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 12, 2015 2:23 PM
Points: 4,254, Visits: 7,190
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 @ 10:06 AM
Points: 5,040, Visits: 12,000
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1341723
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse