Solved

SQL 2008 sqlservr and sqlagent services

Posted on 2011-09-21
2
233 Views
Last Modified: 2012-05-12
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
Comment
Question by:motioneye
2 Comments
 
LVL 18

Assisted Solution

by:ShogunWade
ShogunWade earned 200 total points
ID: 36572423
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 300 total points
ID: 36575294
>>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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question