Home Dashboard Directory Help
Search

SQL Agent Starts then Stops Immediately - SQL 2008 CTP5 by Denver Griffith


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


0
0
Sign in
to vote
Type: Bug
ID: 327299
Opened: 2/5/2008 11:48:44 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
Posted by Denver Griffith on 2/8/2008 at 1:41 PM
Hi Richard,

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.

Thanks!
Posted by Microsoft on 2/8/2008 at 9:01 AM
gauntletnfo,

The agent.out file basically shows a completely normal (if short) life for Agent....
2007-11-28 11:00:10 - ? [131] 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?

-Richard
Posted by Denver Griffith on 2/6/2008 at 11:38 AM
Hello Richard,

Attached the SQLAgent.out to the case.

Thanks,
Denver Griffith
Posted by Microsoft on 2/6/2008 at 11:03 AM
Guantletnfo,

We need the sqlagent.out file to even start to understand what's going on here.

-Richard Waymire
PM, SQL Server Agent
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SQLAGENT.OUT (restricted) 2/6/2008 -