Solved

SQL Server 2005 Agent jobs failing to run after domain change

Posted on 2015-02-21
2
180 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
[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
2 Comments
 
LVL 13

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I exclude some wording in a like statement? 39 83
How come this XML node is not read? 3 53
SQL- GROUP BY 4 51
SQL query 7 49
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Backup & Restore 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.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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