Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2016-08-23
1
Medium Priority
?
34 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 13

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

618 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