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 ««12

SQL Server Agent won't start Expand / Collapse
Author
Message
Posted Friday, March 7, 2008 5:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, Visits: 263
sorry, forgot to include the message on the result pane

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.





------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!
Post #465772
Posted Friday, March 7, 2008 7:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 28, 2009 9:52 AM
Points: 325, Visits: 263
thanks all,
after i executed the block of code (Phillip's) and refreshed my connection, i could open the properties of SQLSERVERAGENT, which prior to now had been greyed out(disabled).

As i went through each of the tabs, i realised i had mistakenly typed the server name in the "alias local host server" box in the connection tab. i deleted the entry and restarted the agent and it worked!!

i haven't sorted out the notification mailing though, but i'm glad scheduled jobs can run now.

thanks again





------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!!
Post #465828
Posted Thursday, March 20, 2008 5:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:47 AM
Points: 279, Visits: 653
Hi,

I've had the same problem: enabling Agent XPs didn't help.

I've managed to fix it by repairing the Native Client setup:

-Select "Run the SQL Native Client Installation Wizard" in the setup screen
-Click "Next"
-select "Repair" and click "Next"
-Click "Install" and "Finish"

Try to start the service now.
Post #472163
Posted Thursday, March 20, 2008 5:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:18 AM
Points: 2,153, Visits: 645
bimpe_d (3/7/2008)
thanks all,
after i executed the block of code (Phillip's) and refreshed my connection, i could open the properties of SQLSERVERAGENT, which prior to now had been greyed out(disabled).

As i went through each of the tabs, i realised i had mistakenly typed the server name in the "alias local host server" box in the connection tab. i deleted the entry and restarted the agent and it worked!!

i haven't sorted out the notification mailing though, but i'm glad scheduled jobs can run now.

thanks again


Hi bimpe_d,

Great result and thanks for update!!

Phillip Cox
MCITP - DBAdmin
Post #472166
Posted Sunday, January 18, 2009 7:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:54 AM
Points: 1,274, Visits: 2,937
awesome xanthos...it worked for me..thanks
Post #639058
Posted Wednesday, March 16, 2011 7:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:18 PM
Points: 18, Visits: 143
Hi There

I have this issue, but I get no logging of any errors in the Windows event log or in the SQL Server logs, infact the last error log in the SQL Server agent log is about 2 months old.

The server was migrated from one VMWare Host to another and I had to re-install SQL server, after an unistall because the repair wouldn't work, I guess it could be an issue there, but I can't see what?

Any help appreciated
Post #1079429
Posted Friday, May 16, 2014 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 16, 2014 10:51 AM
Points: 1, Visits: 7
I went to the trouble of setting up a new account just so I could post here and say thanks to xanthos.

This problem was making me crazy till I read your post and went to add/remove programs and repaired like you said.
Post #1571818
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse