Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

SQL 2008 sqlservr and sqlagent services

Hi,
I have two server with similar setup and db configuration, both server will have access to another server to run and save some files.
in serverA I have to change sqlservr and sqlagent services to run under domain account before I can access the shared path
but in serverB I can use LocalSsystem to access the shared path.

I'm now confused why I can't have localsystem to run in serverA

We run windows 2008 and sql2008
0
motioneye
Asked:
motioneye
2 Solutions
 
ShogunWadeCommented:
Check the permissions that have been granted to the local service account  also you might want to check that the machines are in the same AD OU just incase there are different policies in place on different OUs in your organization.
0
 
Anthony PerkinsCommented:
>>I'm now confused why I can't have localsystem to run in serverA<<
Does the SQL Server service need access to resources outside of serverA?  If the answer is yes, then you will have to use a domain account.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now