Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aufaakif
Starting Member
2 Posts |
 Posted - 2009-07-28 : 02:30:57
|
| we have SQL Server 2005 Engine that worked fine but yesterday SQL Agent was stopped. The error is (from event viewer):SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).Source : SQLSERVERAGENTwe change the user account to local user and grant access as administrator. but we still have the same error.if someone suggest me a valuable information, i woul be very happy.thank you |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-28 : 02:53:10
|
| hiGo into the "Services" of the server and reset the account information there. Be sure you have the correct password.Settings/Control Panel/Administrative Tools/Services - then right click both and make sure they are set right.-------------------------R.. |
 |
|
|
aufaakif
Starting Member
2 Posts |
Posted - 2009-07-31 : 02:18:02
|
quote:
Originally posted by rajdaksha
Go into the "Services" of the server and reset the account information there. Be sure you have the correct password.
What do you mean the account information and how i do that?Do you mean Log on account that run this service?rgds |
|
|
|
|
|
|
SQL Server Agent failed to start