[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 37
  • 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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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