My sql server agent service is not running. i have tried it from service manager(icon on the task bar),from services(in Administrative Tools),from management(in sql server tree). it does not show any error message. when I click start button from any of the above describe source any, it simply busy the mouse icon and free it after some time. Service account's password of both sqlserver and serveragent are of same type(I use domain account). Please help me out

Thanks and Regards Satendra

-- Anonymous, February 20, 2005

Answers

Satendra,

Here are some suggestions/possible causes (in no particular order):

1. Check the SQL Error log or the Windows NT application log. They may provide some explicit hints.

2. Databases trying to recover will stop the agent from starting.

3. The email account may be hung while trying to connect to the email server. If this is the case, the solution is to set the SQL Server Agent to not start automatically, and then restart your server. Your SQL Server Agent will now be stopped instead of stuck in starting mode. Remove the email setup for the SQL Server Agent. Then you should be able to start the SQL Server Agent with no problem. You will need to research what the email problem is.

4. SQL Agent may be running on a login that does NOT have SQL admin privilege.

Good Luck,

Eric

-- Anonymous, February 21, 2005