SQL Server Agent not starting

• sivaprasad

  SSCertifiable

  Points: 6183

  More actions

  July 29, 2005 at 10:25 pm

  #88319

  After Upgrade SQL Server 2000 over SQL Server 7.0 Standard Edition on a box, SQL Server Agent not starting.

  The below error message logged on Windows Event Viewer.

   

  SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

   

  Appreciate any help on this.

  - S Siva Prasad

  Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

• Johan Bijnens

  SSC Guru

  Points: 135375

  More actions

  July 31, 2005 at 8:12 am

  #578365

  Did you also switch service-accounts ?

  did you kick out builtin-administrators ? If yes, check sqlagent is not running on localsystem !

  Did you have a blanc sa-password and change it during upgrade : Check if you also changed this for sqlagent ?

   

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Satendra Singh

  Valued Member

  Points: 72

  More actions

  July 31, 2005 at 8:39 pm

  #578400

  Hi,

   

  Pls. refresh the service acount passward for both mssqlserver and agent services.and then try u will come out with the success.

  Pls. revert back after doing so.

  Regards

  Satendra Singh