Issue :-
When job fails and job owner is a domain login which do not have access to server
Cause :-
SQL agent services will not be running with a domain account thus it is not able to verify the domain login. Also the account doesn't exist on domain any more.
Remediation Steps :-
1. Xp_logininfo (‘account name’). Run the command and if it return NULL that means the server is not able to verify the domain account.
2. Change the job owner to SA and re-run the job. It will run successfully.
When job fails and job owner is a domain login which do not have access to server
Cause :-
SQL agent services will not be running with a domain account thus it is not able to verify the domain login. Also the account doesn't exist on domain any more.
Remediation Steps :-
1. Xp_logininfo (‘account name’). Run the command and if it return NULL that means the server is not able to verify the domain account.
2. Change the job owner to SA and re-run the job. It will run successfully.
No comments:
Post a Comment