July 28, 2016 at 6:01 am
The SQL Server 2008R2 Agent service ran fine until I installed Service Pack 3. Now it starts and then stops.
Is there a solution other than uninstalling the service pack?
Thanks,
Tom
July 28, 2016 at 6:11 am
What is the exact error when you try to start the Agent service from the SQL Configuration Manager?
What's in the Agent log file when you try to start it?
What's in the Windows Event logs (Application and System) when you try to start the Agent?
Right now, you haven't provided enough information for us to even begin to try to make a guess as to the problem or the possible solution.
July 28, 2016 at 3:48 pm
The Windows Application Log should give a reason for service startup failure, like bad username/password, etc. Is anything listed there?
Also, in the LOGS directory where the SQL Server Error Logs are listed there should be a set of SQLAGENT logs as well. Open up the most recent and see if it has anything relevant listed.
Joie Andrew
"Since 1982"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply