The SQLSERVERAGENT service on MSSQLSERVER started and then stopped

While trying to start the SQL Server 2000 Agent services you might get following error message:

The SQLSERVERAGENT service on MSSQLSERVER started and then stopped.

This could be because you might have recently changed the password of the sa account. To make sure go to the SQL Agent log output file. By default it would be under "%ProgramFiles%\Microsoft SQL Server\MSSQL\LOG\" folder. Open it and if you see following message:

2000-12-01 04:05:46 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2000-12-01 04:05:46 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2000-12-01 04:05:46 - ? [098] SQLServerAgent terminated (normally)


The above message in the LOG file confirms that password for sa is wrong. To correct it go to the properties of the SQLServer Agent as below:

And in the properties window go to Connection tab and modify the password for the sa account as below:
 

Now try to start the SQLAgent services and it won't give any error.

Comments

Make Money from Surveys

Popular posts from this blog

Schema.Object has an unresolved reference to Schema

The current master key cannot be decrypted

There is insufficient memory available in the buffer pool