The Multifunctioning DBA

Oct 20 2010   4:16PM GMT

SQL Server Agent Not Starting



Posted by: Colin Smith
Tags:
SQL Server
SQL Server Administration
SQL Server Agent

This week I ran into a strange issue where one of my servers agent accounts would not start up. The SQL Server and the SQL Agent both use the same domain account and the Server was running just fine. The error in the event viewer was a bit strange. It was the following error:

SQLServerAgent could not be started (reason: Unable to connect to server ‘Some Strange Name’; SQLServerAgent cannot start).

After looking into this I found that someone had modified the SQL Server Agent connection properties withing SSMS and had put the ‘Some Strange Name’ into the Alias Local Host Server field.  After looking up what that field does, http://msdn.microsoft.com/en-us/library/ms175176.aspx, I decided that I did not have to have anything in that field. I removed the entry, hit OK and then tried to start the service and what do you know. It all works now.

Hope that helps if anyone else is having issues like that.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: