SQL Server Jobs Agent

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

Answer 1

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

Answer 2

User-523908551 posted

Hi,

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

Answer 3

User-2024178180 posted

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

Answer 4

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