?
Solved

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

Posted on 2016-08-23
1
Medium Priority
?
31 Views
Last Modified: 2016-08-26
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
Comment
Question by:ferrarista
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 12

Accepted Solution

by:
Brian Murphy earned 2000 total points
ID: 41767215
Both domain accounts need to be added to SQL Permissions under Security.

With enough permissions to read the perspective databases.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

777 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