Solved

SQL Server 2005 Agent jobs failing to run after domain change

Posted on 2015-02-21
2
174 Views
Last Modified: 2015-02-22
I have an SQL Server Agent Job set to run as HPRS\mark. This was the user Id when the host was connected to the old domain. It has since been joined to a new domain. I was able to remove this user from all database ownership and add the new domain user. which happens to have the same domain\ID. That all worked fine.

The Agent job has been failing with:

02/22/2015 02:08:56,Backup HPRS Pension databases,Error,0,SERVER\TRAVERSE105,Backup HPRS Pension databases,(Job outcome),,The job failed.  Unable to determine if the owner (HPRS\mark) of job Backup HPRS Pension databases has server access (reason: Could not obtain information about Windows NT group/user 'HPRS\mark'<c/> error code 0x5. [SQLSTATE 42000] (Error 15404)).  NOTE: Failed to notify 'sbsadmin' via email.,00:00:00,0,0,,,,0

So, I tried to change the 'Run as user' in the job > Advanced tab. I was able to change the 'owner' of the job to the new HPRS\mark, and I was able to delete the 'Run as user', but when I try to add the user HPRS\mark it is not on the list - see image. What's my problem?
set-run-as-user.jpg
0
Comment
Question by:jmarkfoley
2 Comments
 
LVL 12

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 40623984
The "Browse for..." window only lists logins which have been created as SQL Server logins. Can you check if the appropriate login is available under the Security node in SSMS for your SQL Server instance?
0
 
LVL 1

Author Comment

by:jmarkfoley
ID: 40624294
Nakul Vachhrajani:
The "Browse for..." window only lists logins which have been created as SQL Server logins
Ah! How did I not know that? I set this up originally, but it's been a while. The browse on General > Owner *did* list all users --- hmm, I'm sure there must be logic behind this somehow. Anyway, I just skipped the browse bit and typed in "HPRS\mark" directly and it worked fine!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now