Solved

SQL Server 2005 Agent jobs failing to run after domain change

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

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

19 Experts available now in Live!

Get 1:1 Help Now