Tuesday, September 11, 2012

Issue 3 :-TSQL command to check if the Login has access to server

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.

No comments:

Post a Comment