March 30, 2006 at 7:45 am
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
March 30, 2006 at 8:07 am
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
March 31, 2006 at 6:21 am
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
March 31, 2006 at 9:03 am
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
March 31, 2006 at 9:36 pm
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