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: Friday, November 14, 2014 5:18 PM
Points: 248, Visits: 1,052
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: Monday, November 24, 2014 5:46 AM
Points: 4,031, Visits: 7,172
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: 2 days ago @ 2:58 PM
Points: 4,655, Visits: 11,126
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