Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the 'Local System Account' 2

Status
Not open for further replies.

Skittle

ISP
Sep 10, 2002
1,528
US
I've read on a MS page that unattended installs of SQL Server will use the local system account if none is specified.

What is mean by the 'local system account'?
Is that which ever account is logged in for the execution of the install?

Dazed and confused
(N+, MCAD)
 
When SQL is installed, some services are installed with it. The two main ones, MSSQLServer, and SQLServerAgent need to be logged in as a user account in some cases such as using SQLMail or backing up a database to a directory that requires permissions. For most installs of SQL Server, the local system account works perfect.



Ray D'Andrade
 
The local system account is a builtin account that can't be modified. It's used to start most services. All services have to start running under an account of some sort. The default account for most services is the local system account. By using this account the services get administrative rights on the local machine (server or workstation), but no rights to any other machine on the network or domain.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
So is the System account in fact the 'Administrator' account that you can see within
Administrative Tools-->Computer Management-->Local Users And Groups-->Users or is it a hidden account not listed?

Dazed and confused
(N+, MCAD)
 
It's NOT the Administrator account and it isn't listed in active directory. It is a hidden built in account. When you do things like give NTFS permissions, you can add System to the list.


Ray D'Andrade
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top