SQL Server Job failed due to service account locked out

SQL Server Administration
1

Hi ,
I am facing issue for sql jobs as its failing due to service account locked out.
Need to again run the same manually and successfully, which it taking time and re work.

Please suggest , how to tackle the issue while jobs are auto running , there should be the issue due to service account locked out.

Thanks.

2

You need to contact your security administrator and have them unlock the account, if you don't have rights to do it yourself. Either that, or change the SQL Agent service account to something else that isn't locked.

1 Like