• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 41
  • Last Modified:

SQL Server 2008 R2 - SQL Server Agent instances running with different domain accounts - problem

Hi guys,

I have on the same server 2 SQL Server instances. For each one, the relevant SQL Server Agent runs with its dedicated domain account.
Both domain accounts used to run the two SQL Server Agents are NOT local admins on the SQL Server Windows box. So far so good.

Now, I have a job running under Instance A that needs to backup a database from instance B. The error I get is "Executed as user DOMAIN\InstanceB_User. Login failed for user DOMAIN\InstanceB_User"

Now, how should I resolve this problem ? Should both SQL Server Agent instances share the same service user for the respective SQL Server Agent ? Or can I keep a dedicated one for each instance and make them both local admin ? Or.... ?

NOTE: SQL Server services for the two instances still run using local system (only SQL Server Agents have domain users to logon as).

Thanks for your input.
0
ferrarista
Asked:
ferrarista
1 Solution
 
Brian MurphyIT ArchitectCommented:
Both domain accounts need to be added to SQL Permissions under Security.

With enough permissions to read the perspective databases.
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