August 6, 2010 at 12:09 am
I just did the upgrade on SQL 2005 server and could not turn on the SQL Server Agent. The error message is " The System cannot find the file specified" while starting the agent.
Which file SQL Agent is looking for when I start the Agent services ?
August 6, 2010 at 3:19 am
Please check if SQLAGENT.OUT file has any error messages at the time of this error. If the SQLAGENT.OUT file does not have entries during that time frame, I feel Agent service is unable to locate SQLAGENT.OUT file. Check if the Agent service start up account has permission on that folder.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 6, 2010 at 8:07 am
This is what I got in the SQLAGENT.OUT file. Do you think if there is any thing related to the mail session ?
2010-08-05 14:50:10 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 ((Unknown) unicode retail build) : Process ID 496
2010-08-05 14:50:10 - ? [101] SQL Server SCDC313AS version 9.00.4053 (0 connection limit)
2010-08-05 14:50:10 - ? [102] SQL Server ODBC driver version 9.00.4035
2010-08-05 14:50:10 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2010-08-05 14:50:10 - ? [310] 1 processor(s) and 4096 MB RAM detected
2010-08-05 14:50:10 - ? [339] Local computer is SCDC313AS running Windows NT 5.2 (3790) Service Pack 2
2010-08-05 14:50:11 - ? [432] There are 11 subsystems in the subsystems cache
2010-08-05 14:50:11 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-08-05 14:50:11 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2010-08-05 14:50:11 - + [260] Unable to start mail session (reason: No mail profile defined)
2010-08-05 14:50:11 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-08-05 15:19:03 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2010-08-05 15:19:05 - ? [098] SQLServerAgent terminated (normally)
August 6, 2010 at 8:27 am
check the permissions on [NT SERVICE\SQLSERVERAGENT], i think the upgrade may have removed the service account
August 6, 2010 at 8:50 am
Looks pretty clear to me -- The Agent started cleanly at 2:50 PM and was told to stop at 3:19 PM. It seems to have run for 30 minutes without error. Are you sure it wasn't up then?
The mail profile not being configured simply means that it won't send out email if there are job failures, so that's not an error.
I would look in the Windows Application event log to see if there might be more info. If a user shut it down, that should be logged there.
EDIT: Just realized that the date was yesterday. Make sure that this file's date stamps correspond to your app running. It may be the old version's log.
Again, check the Windows event log for some more details.
August 6, 2010 at 10:01 am
Actually, I am doing upgrade from 2005 to 2008 SQL server and getting following error.
Wait on the Database Engine Recovery handle failed. Check the SQL Server error log for potential causes.
I think if this issue will fix then I am sure I will have SQL Agent issue. I did upgrade to 2008 on other server successfully but some how this server is having a problem.
August 6, 2010 at 10:02 am
Oops. correction.
I think if this issue will fix then I am sure I will not have SQL Agent issue. I did upgrade to 2008 on other server successfully but some how this server is having a problem.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply