sql server agent not starting 2

[ktucci]

does anyone have any idea why after a sql 7 -> sql 2000 upgrade sql server agent will not start...it does not give a specific error but it returns an error stating 'could not start service on local computer'...

thanks

keith

 

[tlbroadbent]

Check this article.

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q237604

Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[fluteplr]

most often sql agent is set to use a login rather than a system account and either the login has been removed or its password changed

 

[ktucci]

the problem was that the login had changed since the upgrade took place....thanks for everyones help

keith

 

[Bernadette]

Hi There

I have the same problem. I recently changed the sa password on the SQL Server (7.0). The SQL Agent is running under the System Account, but now it wont start. I have tried it running under the SQLServerAdmin NT Account but nothing. I have read the KB Q237604 article and tried that but still nothing. The following error is from the SQL Agent Error Log


[298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]


I dont understand as the SQLAgent isnt using the 'sa' account. If anybody has any ideas I would be very grateful for the help.

Bernadette :-> Bernadette

 

[ktucci]

i finally got my sql agent started through controlpanel->services by changing the username and password to the current login for that machine...after that it started and worked fine since...

keith

 

[Bernadette]

Hi Guys

Just to let you know that I found the problem to my above question. I used Q259710 - PRB: SQL Server Agent Fails to Start On Windows 9x When you change the 'sa' password, even though it is a WindowsNT4 server.

Seeemingly there is bug to this effect in SQL7.0 and SQL2000.

Hope This Helps and Thanks for your advice. Bernadette