Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent troubles - The system cannot find the file specified. Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 1:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,379, Visits: 2,687
Hi All

I have a SQL 2005 system.
The SQL Service is started with no issues - However, I can't seem to start the SQL Agent. System error logs indicate: The system cannot find the file specified

I checked the service and I noticed that the Path to the SQLAGENT90.EXE is a location that doesn't exist.

>> Why would this reflect a location that doesn't exist?
>> How do I change it to the correct location?
>> Do I copy the SQLAGENT90.EXE to the location specified?

Any help would be great

Thanks
Post #1426631
Posted Tuesday, March 5, 2013 3:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:34 PM
Points: 1,219, Visits: 1,690
Are there multiple instances of SQL2005 installed on the box? (ie are you looking at the correct SQL Agent service?)
Open SQL Configuration Manager and check it there.

What's changed recently on the box? Patch? Failed SQL installation/upgrade? SQL express installed?
Who else has access to the machine? Check Windows application and system logs for changes. When did the error start occuring? Go back in the Windows Security log to see who logged in at that time.

If it has been moved or deleted, I wouldn't trust anything on the box and would reinstall SQL rather than try repair it.
Post #1426690
Posted Tuesday, March 5, 2013 3:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,379, Visits: 2,687
foxxo (3/5/2013)
Are there multiple instances of SQL2005 installed on the box? (ie are you looking at the correct SQL Agent service?)
Open SQL Configuration Manager and check it there.

What's changed recently on the box? Patch? Failed SQL installation/upgrade? SQL express installed?
Who else has access to the machine? Check Windows application and system logs for changes. When did the error start occuring? Go back in the Windows Security log to see who logged in at that time.

If it has been moved or deleted, I wouldn't trust anything on the box and would reinstall SQL rather than try repair it.


This is a server I inherited so not sure as to what has happened recently

Post #1426693
Posted Wednesday, March 6, 2013 1:16 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:11 PM
Points: 1,775, Visits: 1,324
I would agree with foxxo, in that a reinstall would be the most simple solution.

However, if you are up for a taking a risk, I recall the location of the SQLAGENT90.EXE path is located in the registry.


Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1427606
Posted Wednesday, March 6, 2013 10:50 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,379, Visits: 2,687
Meet George Jetson (3/6/2013)
I would agree with foxxo, in that a reinstall would be the most simple solution.

However, if you are up for a taking a risk, I recall the location of the SQLAGENT90.EXE path is located in the registry.


Thanks

A reinstall is not really on the cards right now - I have managed to find the key in the registry where the path to SQLAGENT90.EXE is kept. I have made the change on a test system and it seems to work without any issues.

Post #1427773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse