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: Today @ 1:39 PM
Points: 235, Visits: 984
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: Thursday, September 18, 2014 10:38 PM
Points: 3,931, Visits: 7,160
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 4,323, Visits: 10,572
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