I searched the forum and found the above error code in 4 other threads but none of them related exactly to what I am seeing.
We are running TDP for Sql 6.4.0. The sql server is 2012 and windows 2012. Starting last week on 3 of the 25 servers that have the same configuration we randomly started receving the error message:
ACO5426E The SQL log on does not have the Sysadmin role
But only for some of the schedules, we run one full backup at 7PM and logs every 2 hours. in the last 24 hours on one of the servers this is what we saw:
3/25/2015 10:30 Successful
3/25/2015 12:30 Successful
3/25/2015 14:30 failed ACO5426E
3/25/2015 16:30 Successful
3/25/2015 18:30 failed ACO5426E
3/25/2015 19:00 failed ACO5426E
3/25/2015 20:30 failed ACO5426E
3/25/2015 22:00 failed ACO5426E
3/26/2015 12:30 failed ACO5426E
3/26/2015 2:30 Sucessful
3/26/2015 4:30 failed ACO5426E
3/26/2015 6:30 Successful
3/26/2015 8:30 Successful
3/26/2015 10:30 failed ACO5426E
The success/failures are not at the same times on the 3 servers.
We are running the SQL schedulers as specific user and i verified that user does have the sysadmin role.
I would expect if this was really a permissions issue then the schedule would fail everytime.
Any ideas.
THank you in advance.
We are running TDP for Sql 6.4.0. The sql server is 2012 and windows 2012. Starting last week on 3 of the 25 servers that have the same configuration we randomly started receving the error message:
ACO5426E The SQL log on does not have the Sysadmin role
But only for some of the schedules, we run one full backup at 7PM and logs every 2 hours. in the last 24 hours on one of the servers this is what we saw:
3/25/2015 10:30 Successful
3/25/2015 12:30 Successful
3/25/2015 14:30 failed ACO5426E
3/25/2015 16:30 Successful
3/25/2015 18:30 failed ACO5426E
3/25/2015 19:00 failed ACO5426E
3/25/2015 20:30 failed ACO5426E
3/25/2015 22:00 failed ACO5426E
3/26/2015 12:30 failed ACO5426E
3/26/2015 2:30 Sucessful
3/26/2015 4:30 failed ACO5426E
3/26/2015 6:30 Successful
3/26/2015 8:30 Successful
3/26/2015 10:30 failed ACO5426E
The success/failures are not at the same times on the 3 servers.
We are running the SQL schedulers as specific user and i verified that user does have the sysadmin role.
I would expect if this was really a permissions issue then the schedule would fail everytime.
Any ideas.
THank you in advance.