SQL Server Home
SQL Agent Starts then Stops Immediately - SQL 2008 CTP5
as Not Reproducible
2/5/2008 11:48:44 AM
User(s) can reproduce this bug
Using SQL 2008 CTP5 whenever I try to start the SQL Agent it gives an error that it started and then stopped. In the application log it has an entry for the SQL Agent stopping and then stopping normally. I am using a domain account that is in the local administrators group (has sysadmin permissions on the instance). I double-checked the password and tried the Local Service account with no luck.
Also, tried using the RECONFIGURE sp_configure to set the Agent XPs to 1 with success, but when I try to start the SQL Agent the Agent XPs goes back to 0.
SQL Server 2008 November CTP
Tools (SSMS, Agent, Profiler, etc.)
Windows Server 2003 (all x64 editions)
Operating System Language
Steps to Reproduce
Install SQL 2008 CTP5 including only the database engine, Integration Services, and SQL Agent. Attempt to start the SQL Agent.
When you try to start the SQL Agent it gives an error that it started and then stopped.
SQL Agent starts.
to post a comment.
Please enter a comment.
on 2/8/2008 at 1:41 PM
Thanks for your help! I discovered that the drive letter for the SQL Agent error log had changed. Tried changing it throught SQL Server Configuration Manager but that didn't do it. Then found that I had to manually change the drive letter for it in the registry then it started up fine.
on 2/8/2008 at 9:01 AM
The agent.out file basically shows a completely normal (if short) life for Agent....
2007-11-28 11:00:10 - ?  SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS.
This line indicates someone else asked Agent to stop again.... Do you know of any other process that would have been asking agent to stop?
on 2/6/2008 at 11:38 AM
Attached the SQLAgent.out to the case.
on 2/6/2008 at 11:03 AM
We need the sqlagent.out file to even start to understand what's going on here.
PM, SQL Server Agent
to post a workaround.
Please enter a workaround.
© 2014 Microsoft