Thursday, July 26, 2012

Token based server access validation failed with an infrastructure error.Check for previous errors [CLIENT:IP ADDRESS]

After migrating one of the production servers, I noticed this error in the  SQL Server log file viewer.
To resolve this, first I took the IP address [IP ADDRESS listed in the error] and did a nslookup on the ipaddress to get the servername.


I logged on the server and checked the job history and noticed that one of the jobs was failing.










The error indicated that the user did  not have permissions to access the new upgraded server.The solution was to add that user to the new server  and grant access to the database on the new upgraded server.Once added the sql job on the server executed without any issues.

No comments: