March 4, 2008 at 7:31 am
Hi,
Would like to know what is the difference between Local System, Local service & Network service account types...
March 4, 2008 at 7:37 am
Local Service is recommended for local services that do not need to access the network. It provides limited rights. Local system is similar to the administrative account (local) and has lots of rights that most services don't need.
Network service is like local service, except it has network access with the rights of the computer's account on the network.
March 4, 2008 at 7:44 am
Thanks steve for the reply..when is a service configured as LocalService and when is it done as Localsystem...
I understand that in case any sql service needs access to a network (as inh the case of DTS packages) the Network service comes into play..
March 4, 2008 at 11:21 am
vaidyanathan_kalyanasundaram (3/4/2008)
Thanks steve for the reply..when is a service configured as LocalService and when is it done as Localsystem...I understand that in case any sql service needs access to a network (as inh the case of DTS packages) the Network service comes into play..
I would recommend using a doman account for SQL Server Agent/Sql Server when the service will need to access network resources.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2008 at 10:12 pm
Hi Jack,,
You mean to say that as the Sql server agent needs to access network resources(and hence it is a network service), it be configured with a domain account??
March 4, 2008 at 11:31 pm
Yes, If you have jobs that need to access the network then your SQL Server Agent must be configured with a domain account. For ex:- if u have log shipping then you need to access the network.
"Keep Trying"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply