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\T
,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?