locked
SQL Server Jobs Agent RRS feed

  • Question

  • User-523908551 posted

    Hi All,

    I am using MS-SQL Server 2005 database in my project and have created SQL Server Agent jobs. These jobs are scheduled to run on the daily basis. Now when i change the password of my machine login account these jobs stop running. Before changing the password they were working.

    Do i need to make some changes in setting in SQL Server. Any help on this would be appreciated.

    Thanks

    Monday, August 10, 2009 7:04 AM

Answers

  • User2011918074 posted

    Hi,

    I think you can refer to the following KB article to update the password information the SQL Server Agent service:

    SQL Server service does not start successfully because of a logon failure
    http://support.microsoft.com/kb/282254

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 13, 2009 4:06 AM

All replies

  • User-2024178180 posted

    go to control panel->administrative tools->services->Sql Server Agent
    right click on SQL Server Agent
    click on Properties
    go to "Log On" tab
    select "local System account"
    click ok
    restart service

    go to control panel->administrative tools->services->Sql Server Agent


    right click on SQL Server Agent


    click on Properties


    go to "Log On" tab


    select "local System account"


    click ok


    restart service

    Monday, August 10, 2009 8:37 AM
  • User-523908551 posted

    Hi,

    Thanks for reply. Local Sysyem Account is already checked but the problem still persists.


    Tuesday, August 11, 2009 7:31 AM
  • User-2024178180 posted

    can you do the same for all SQL Server related services? like sql server, sql server agent, sql browser etc.


    Wednesday, August 12, 2009 3:37 AM
  • User2011918074 posted

    Hi,

    I think you can refer to the following KB article to update the password information the SQL Server Agent service:

    SQL Server service does not start successfully because of a logon failure
    http://support.microsoft.com/kb/282254

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 13, 2009 4:06 AM