Post reply

SQL Server Agent wont start

  • April 29, 2008 at 2:03 am

    #185886

    Greetings,

    I am having a problem where i can not get the SQL server Agent to start. im running SQL server 2005 version 9.0.3042.

    Basically it happend when i tried to create an alias instance name by click on the properties of the SQL server Agent. Once i typed the alias instance the agent went offline and didnt come back on again. i can no longer select the properties to undo the changes

    it says (Agent XPs disabled) next to it.

    any feed back would be great!

    Thanks

  • April 29, 2008 at 2:48 am

    #808180

    Hi

    Check out this link

    http://www.sqlservercentral.com/Forums/Topic367977-146-1.aspx

    Hope this helps

    "Keep Trying"

  • May 5, 2008 at 10:02 pm

    #811004

    Thanks for your help however it didnt not resolve the problem.

    I could not find anything invalid registry paths.

    is it possible to reinstall just the agent? or will i need to reintall the entire instance?

  • May 6, 2008 at 10:44 pm

    #811562

    I just did some testing and got the same results - SQL Server Agent wouldn't start after setting an alias. I didn't have to reinstall, however. Here's what I did:

    Fire up SQL Server Configuration Manager. Go into SQL Native Client Configuration\Aliases. Create a new alias with the same name as the alias you specified in the SQL Agent configuration (natch). If you can't remember what it was, you can look in the registry under HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent, ServerHost value.

    Make the alias TCP/IP, specify the port SQL Server is listening on (default is 1433).

    Check your SQL Server is listening on TCP/IP by looking under SQL Server 2005 Network Configuration\Protocols. Enable TCP/IP if it isn't already. This will require a reboot.

    Start SQL Server Agent.

    There may be another way to do this, but this is what worked for me. It should work with Named Pipes as well. Or by clearing the value in ServerHost via regedit (dirty, last resort sort of hack).


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply