Solved

SQL Server 2005 Agent jobs failing to run after domain change

Posted on 2015-02-21
2
178 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

749 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