Solved

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

Posted on 2016-08-23
1
25 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
1 Comment
 
LVL 12

Accepted Solution

by:
Brian Murphy earned 500 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 Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

713 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