After migrating one of the production servers, I noticed this error in the SQL Server log file viewer.
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.
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:
Post a Comment