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 Server Agent - "1% is not a valid win32 application" Expand / Collapse
Author
Message
Posted Monday, October 01, 2007 4:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 21, 2007 5:45 PM
Points: 3, Visits: 7
Hi,

when I click the button "start" in SQL Server Agent services, error message appears. Below is the error message

"1% is not a valid win32 application"

When I restart the Server, and do it again, same error appears.

Help!....my last option will be "re install" the SQL server 2000.

thanks in advance.
Post #404921
Posted Monday, October 01, 2007 4:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 06, 2014 2:38 AM
Points: 398, Visits: 2,423
Where did you choose "Start"? in the Enterprise Manager? I dunno if this can help but try it anyways who knows maybe this make your server agent starts..


START>SETTING>CONTROL PANEL>ADMINISTRATIVE TOOL>SERVICES>Find SQLSERVERAGENT>Right Click then choose start

Hope that helps....



"-=Still Learning=-"

Lester Policarpio

Post #404935
Posted Monday, October 01, 2007 6:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 21, 2007 5:45 PM
Points: 3, Visits: 7
Yes, I clicked start in Enterprise Manager. I also tried in SQL Server Service Manager (the one in the taskbar).

Actually Sir, I also tried that in SERVICES but it is still not able to start.
Post #405323
Posted Monday, October 01, 2007 8:13 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 06, 2014 2:38 AM
Points: 398, Visits: 2,423
I searched the net bout the error you recieved and it gave me 1 good URL try this one it could help

http://support.microsoft.com/kb/812486


"-=Still Learning=-"

Lester Policarpio

Post #405351
Posted Sunday, October 21, 2007 5:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 21, 2007 5:45 PM
Points: 3, Visits: 7
I find the cause of error.....the Master was corrupted....What I did was..

1. Copy the backup of *Master
2. Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\rebuilm.exe then point to the *Master where it located.

that's it....SQL services is now ON

thanks for your time...
Post #413232
Posted Friday, June 13, 2008 3:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 28, 2014 10:41 AM
Points: 9, Visits: 68
Hi, I saw the same issue where agent would not start. Error in event log saying 'Not a valid win32 application'.
FIX:
There may be a file in the root drive (or SQL installation drive) called 'program'. Rename or delete it and the service should restart. Might be relate to SP4 install.
cheers
padraig
Post #516514
Posted Tuesday, October 05, 2010 3:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 05, 2010 4:06 AM
Points: 1, Visits: 1
Thanks Padraig, that worked a treat. I reckon you might be on to something with the SP4 upgrade too. Cheers, Oliver
Post #998173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse