ACO5426E The SQL log on does not have the Sysadmin role

bxtr97

ADSM.ORG Member
Joined
Oct 12, 2010
Messages
29
Reaction score
0
Points
0
PREDATAR Control23

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.
 
PREDATAR Control23

Thank you for the reply, yes i did look at that article and the account that the scheduler service is running as does have the sysadmin role in sql. Also it does not fail everytime. I feel like if it was actually a permissions issue like that then it should never finish successfully when running from the schedule.
 
Top