Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-10-06 : 15:58:57
|
| The job failed. Unable to determine if the owner (mydomain\abc_App) of job ABC_A_my_job_name has server access (reason: Could not obtain information about Windows NT group/user 'mydomain\abc_App', error code 0x5. [SQLSTATE 42000] (Error 15404)).the user is having sysadmin server role, and is not locked. can you please guide me hereArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-10-06 : 16:01:57
|
| what might be the issue with the current user?pleaseArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-10-06 : 16:23:35
|
| When a SQL Server agent job is owned by a user account, it must be authenticated on the domain before it can run. If that cannot be done, the job fails.The check that is done to validate the domain user is case sensitive. If the login is not the same case, it also will fail. For example: MyDomain\MyUser is not the same as MYDOMAIN\MYUSER.The only time I have any agent jobs that are not owned by sa is on a report server where the developers create and manage their own jobs.Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-10-06 : 16:50:49
|
| excellent point...i'll look into it now, and update you statusArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
Job failed with the error