April 18, 2010 at 7:07 am
Below is my server configuration :
---> SQL SERVER 2005 , 62 bit , OS - Windows server 2003
---> Cluster 2 node Active/Passive
On the server storage related patch installation was performed and after that failover happened. Nothing was done to the MSSQL Server Instance. After the failover I saw the Agent server was down and was not comming up . There was red arrow on the sql server agent with the below message :
SQL Server Agent (Agent XPs disabled) .
SQL Server Agent is running on Domain Account.
I tried following options :
a) Manually restarting the SQL Server agent which didnt worked.
b) Chanding the Agent XP to --> 1 (using sp_configure) and this worked Successfully.
Now the question is -- why do we need to change the Agent XP -> 1 when earlier it was working fine without this setting.
April 18, 2010 at 10:39 am
Was agent showing as down in SSMS or in configuration manager?
Possibly Agent was up but not all the databases were recovered following restart, agent_XPs would show as disabled in this scenario.
check in the agent errorlog.
---------------------------------------------------------------------
April 19, 2010 at 4:14 am
Agree with George.
I have two clusters like this and have found that the configuration manager tends to be mis-leading. Rely on Clust Admin and Services.msc (and of course ssms).
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply