Difference between Local System, Local Service, Network Service -- sql server new users

sql server new users : Difference between Local System, Local Service, Network Service

Jens
4/20/2006 1:28:55 PM

Hi,

DId you already google for that ?

http://blogs.msdn.com/esiu/archive/2005/07/19/Eugene.aspx

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Wade
4/20/2006 1:47:43 PM

Under the SQL Server Properties dialog (I'm using SQL Express 2005) the "Log
in as: - Built-in account" lists Local System, Local Service and Network
Service.

What are the differences between these?

If I install SQL Express 2005 on a Windows 2003 Domain Controller, Local
Service and Network Service are not available - these are not supported
under this OS; these services are available under Win XP or a non-Domain
Controller. What functionality would I be missing if I cannot use these
accounts?

Thanks in advance

Wade
4/21/2006 12:00:00 AM

Thanks for your response.

Yes google and msdn and I'm understanding the difference a little better -
although it took awhile to get the right combination of words to use in the
search to get an appropriate number of hits.

But I'm still fuzzy on what is the best account to use on:
--- a domain controller - Local system or a user account
--- a non-domain controller - Local system, Local service, Network
service, user account

The SQL db would need to be accessable only to our company employees (all
computers and users in our domain - 5 subnets) .

Thanks again in advance.

[quoted text, click to view]

Michael Hotek
4/21/2006 12:00:00 AM

The answer to both questions is - user account. Local System has access to
the entire machine which isn't what you want. The user account only has
access to those things that you give it access to.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

Wade
4/21/2006 10:22:02 AM

Thanks Michael, based on my research I was leaning in that direction too.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn