Solved

SQL Server 2005 Agent jobs failing to run after domain change

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

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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