The Multifunctioning DBA

Oct 20 2010   4:16PM GMT

SQL Server Agent Not Starting

Colin Smith Colin Smith Profile: Colin Smith

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,, 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.

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:

Share this item with your network: