Post reply

SQL Agent

  • July 15, 2010 at 5:37 am

    #148076

    Hi,

    We are getting the below error message from the sql server agent service while trying the start the agent " SQLServerAgent could not be started (reason: Unable to connect to server 'AAAAAA\XXXXX'; SQLServerAgent cannot start).

    Same error has been logged in the both sql server agent error log and application log.

    Sql server and Agent was running by the domain user name. Now i can able to start the sql server database engine but i could not start the sql agent. I tried to start the sql agent on both local and domain user but it does not restore the sql agent process.

    Then i tried to connect the sql agent through the cmmand prompt by using the followin command.

    D:\Program Files\Microsoft SQL Server\MSSQL$XXXXX\Binn>sqlagent.exe -c -v -

    i XXXXXX. But here i am getting error message as

    Microsoft (R) SQLServerAgent 8.00.760

    Copyright (C) Microsoft Corporation, 1995 - 1999.

    2010-07-15 03:19:09 - ! [246] Startup error: Unable to read SQLServerAgent registry settings (from SOFTWARE\Microsoft\Microsoft sqL Server\xxxxx\SQLServerAg

    ent)

    2010-07-15 03:19:09 - ? [098] SQLServerAgent terminated (normally)

    Please update your comments to resolvethis issue.

    Thanks in Advance.

  • July 15, 2010 at 6:46 am

    #1193439

    Hi,

    Verify registry keys permissions for the service account. Full list of required permissions is here: http://support.microsoft.com/kb/283811

  • July 16, 2010 at 2:40 pm

    #1194362

    magasvs (7/15/2010)

    Hi,

    Verify registry keys permissions for the service account. Full list of required permissions is here: http://support.microsoft.com/kb/283811

    Thanks for your reply. I will check and let you know.

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

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