SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Agent won't start


SQL Server Agent won't start

Author
Message
Omoba
Omoba
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1219 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!!!Cool
Omoba
Omoba
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1219 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!!!Cool
xanthos
xanthos
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 970
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.
Big Data Man
Big Data Man
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5666 Visits: 750
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
curious_sqldba
curious_sqldba
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19131 Visits: 3765
awesome xanthos...it worked for me..thanks
andymay-496937
andymay-496937
SSC-Addicted
SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)SSC-Addicted (421 reputation)

Group: General Forum Members
Points: 421 Visits: 201
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
PatMoe
PatMoe
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 21
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search