SQL serverAgent tries to connect other machine

  • Hi all.,

    My SQL Server Agent fails to start with sql error log stating

    "failed to coonect 'neighbour_server' "

    though i tried to start local SQL Servert Agent. Access to Builtin/Administartor was ok. Changed service log on to Local System /This Account, but same result.

    Thanks in advance.

    Regards.,

    Sri

  • Is neighbor_server the name of your SQL Server?

    Does the account you set SQL Server Agent to have a login within SQL Server?

    Is is a member of the sysadmin fixed server role?

    K. Brian Kelley
    @kbriankelley

  • Hi bkelley,

    The neighbour server is other SQL Server in LAN. SQL Server Agent doesn't starts even when tried with System , Security, Server role.

    The SQL Server Agent have a login within SQL Server .

    Regards.,

    Sri

  • If I understand your problem right, the SQL Server Agent is pointing to a server other than the one it is installed with. If that's the case, in Enterprise Manager, open up the properties for that SQL Server Agent. Click on the Connections tab and repoint the agent back at the SQL Server the Agent is supposed to correspond to.

    K. Brian Kelley
    @kbriankelley

  • Hi bkelley.,

    Thanks for ur help. It works perfectly.

    Regards.,

    Sri

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

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