| Groups | Blog | Home |
sql server clustering : SQLServerAgent cluster resource failed to start
(without terminal server) When i tried to test the failover by selecting move group from cluster Admin. Every resources succesfully failed over to the other server except SQLServerAgent, it was shown online pending for a while then all the resource failed back to the original server. When I tried to turn off the current primary server and logged on to the second server, all the resources have changed to the second server successfully except SQLServerAgent, its status was shown as failed
The SQL Server log and the System Event viewer should have detaled reasons
why the resource failed to come online. Look there and post what you find. Geoff N. Hiten Microsoft SQL Server MVP [quoted text, click to view] "tvq" <tvq@discussions.microsoft.com> wrote in message news:406AB06D-9FF5-4BE6-B760-AE1AAAB94810@microsoft.com... >I have 2 nodes of SQL 2000 Enterprise edition running on 2 windows 2003 > (without terminal server) > When i tried to test the failover by selecting move group from cluster > Admin. Every resources succesfully failed over to the other server except > SQLServerAgent, it was shown online pending for a while then all the > resource > failed back to the original server. > When I tried to turn off the current primary server and logged on to the > second server, all the resources have changed to the second server > successfully except SQLServerAgent, its status was shown as failed > Anyone has any ideas please
System Event Log
ID:7000 The SQLSERVERAGENT service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. SQLAGENT.2 2005-06-30 13:40:30 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 924 2005-06-30 13:40:30 - ? [101] SQL Server CLUSTERSQL version 8.00.194 (0 connection limit) 2005-06-30 13:40:30 - ? [102] SQL Server ODBC driver version 3.86.1830 2005-06-30 13:40:30 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local) 2005-06-30 13:40:30 - ? [310] 4 processor(s) and 2048 MB RAM detected 2005-06-30 13:40:30 - ? [339] Local computer is CLUSTERSQL running Windows NT 5.2 (3790) Service Pack 1 2005-06-30 13:40:30 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent 2005-06-30 13:40:30 - ? [129] SQLSERVERAGENT starting under Windows NT service control 2005-06-30 13:40:30 - + [260] Unable to start mail session (reason: No mail profile defined) 2005-06-30 13:40:30 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 2005-06-30 13:40:30 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabled 2005-06-30 13:51:15 - ! [LOG] The data portion of event 19002 from MSSQLSERVER is invalid 2005-06-30 16:41:44 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS... 2005-06-30 16:41:47 - ? [098] SQLServerAgent terminated (normally) I can also confirm that the service account used to start SQLServeragent is the same on both server and the log files are on the share RAID disk. thanks [quoted text, click to view] "Geoff N. Hiten" wrote:
> The SQL Server log and the System Event viewer should have detaled reasons > why the resource failed to come online. Look there and post what you find. > > Geoff N. Hiten > Microsoft SQL Server MVP > > "tvq" <tvq@discussions.microsoft.com> wrote in message > news:406AB06D-9FF5-4BE6-B760-AE1AAAB94810@microsoft.com... > >I have 2 nodes of SQL 2000 Enterprise edition running on 2 windows 2003 > > (without terminal server) > > When i tried to test the failover by selecting move group from cluster > > Admin. Every resources succesfully failed over to the other server except > > SQLServerAgent, it was shown online pending for a while then all the > > resource > > failed back to the original server. > > When I tried to turn off the current primary server and logged on to the > > second server, all the resources have changed to the second server > > successfully except SQLServerAgent, its status was shown as failed > > Anyone has any ideas please > >
--->SQL Server CLUSTERSQL version 8.00.194 (0 connection limit)
You must apply SQL Server Service Pack 3a or SP4. You can download this from the Microsoft.com web site. Windows 2003 limits SQL functionality until SP3a or SP4 has been applied. Geoff N. Hiten Microsoft SQL Server MVP [quoted text, click to view] "tvq" <tvq@discussions.microsoft.com> wrote in message news:1A4C0A9D-2A18-40C1-B754-81533EFE1ADC@microsoft.com... > System Event Log > ID:7000 > The SQLSERVERAGENT service failed to start due to the following error: > The service did not respond to the start or control request in a timely > fashion. > SQLAGENT.2 > 2005-06-30 13:40:30 - ? [100] Microsoft SQLServerAgent version 8.00.194 > (x86 > unicode retail build) : Process ID 924 > 2005-06-30 13:40:30 - ? [101] SQL Server CLUSTERSQL version 8.00.194 (0 > connection limit) > 2005-06-30 13:40:30 - ? [102] SQL Server ODBC driver version 3.86.1830 > 2005-06-30 13:40:30 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; > Local host server is (local) > 2005-06-30 13:40:30 - ? [310] 4 processor(s) and 2048 MB RAM detected > 2005-06-30 13:40:30 - ? [339] Local computer is CLUSTERSQL running Windows > NT 5.2 (3790) Service Pack 1 > 2005-06-30 13:40:30 - ! [364] The Messenger service has not been started - > NetSend notifications will not be sent > 2005-06-30 13:40:30 - ? [129] SQLSERVERAGENT starting under Windows NT > service control > 2005-06-30 13:40:30 - + [260] Unable to start mail session (reason: No > profile defined) > 2005-06-30 13:40:30 - + [396] An idle CPU condition has not been defined - > OnIdle job schedules will have no effect > 2005-06-30 13:40:30 - + [408] SQL Server MSSQLSERVER is clustered - > AutoRestart has been disabled > 2005-06-30 13:51:15 - ! [LOG] The data portion of event 19002 from > MSSQLSERVER is invalid > 2005-06-30 16:41:44 - ? [131] SQLSERVERAGENT service stopping due to a > stop > request from a user, process, or the OS... > 2005-06-30 16:41:47 - ? [098] SQLServerAgent terminated (normally) > > I can also confirm that the service account used to start SQLServeragent > is > the same on both server and the log files are on the share RAID disk. > > thanks > "Geoff N. Hiten" wrote: > >> The SQL Server log and the System Event viewer should have detaled >> reasons >> why the resource failed to come online. Look there and post what you >> find. >> >> Geoff N. Hiten >> Microsoft SQL Server MVP >> >> "tvq" <tvq@discussions.microsoft.com> wrote in message >> news:406AB06D-9FF5-4BE6-B760-AE1AAAB94810@microsoft.com... >> >I have 2 nodes of SQL 2000 Enterprise edition running on 2 windows 2003 >> > (without terminal server) >> > When i tried to test the failover by selecting move group from cluster >> > Admin. Every resources succesfully failed over to the other server >> > except >> > SQLServerAgent, it was shown online pending for a while then all the >> > resource >> > failed back to the original server. >> > When I tried to turn off the current primary server and logged on to >> > the >> > second server, all the resources have changed to the second server >> > successfully except SQLServerAgent, its status was shown as failed >> > Anyone has any ideas please >> >> >>
Thanks Geof, I'll give it a go then will post back the result (i'm pretty
sure that I have applied server pack 3 for SQL 2000 En though) [quoted text, click to view] "Geoff N. Hiten" wrote:
> --->SQL Server CLUSTERSQL version 8.00.194 (0 connection limit) > > You must apply SQL Server Service Pack 3a or SP4. You can download this > from the Microsoft.com web site. Windows 2003 limits SQL functionality > until SP3a or SP4 has been applied. > > Geoff N. Hiten > Microsoft SQL Server MVP > > > "tvq" <tvq@discussions.microsoft.com> wrote in message > news:1A4C0A9D-2A18-40C1-B754-81533EFE1ADC@microsoft.com... > > System Event Log > > ID:7000 > > The SQLSERVERAGENT service failed to start due to the following error: > > The service did not respond to the start or control request in a timely > > fashion. > > SQLAGENT.2 > > 2005-06-30 13:40:30 - ? [100] Microsoft SQLServerAgent version 8.00.194 > > (x86 > > unicode retail build) : Process ID 924 > > 2005-06-30 13:40:30 - ? [101] SQL Server CLUSTERSQL version 8.00.194 (0 > > connection limit) > > 2005-06-30 13:40:30 - ? [102] SQL Server ODBC driver version 3.86.1830 > > 2005-06-30 13:40:30 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; > > Local host server is (local) > > 2005-06-30 13:40:30 - ? [310] 4 processor(s) and 2048 MB RAM detected > > 2005-06-30 13:40:30 - ? [339] Local computer is CLUSTERSQL running Windows > > NT 5.2 (3790) Service Pack 1 > > 2005-06-30 13:40:30 - ! [364] The Messenger service has not been started - > > NetSend notifications will not be sent > > 2005-06-30 13:40:30 - ? [129] SQLSERVERAGENT starting under Windows NT > > service control > > 2005-06-30 13:40:30 - + [260] Unable to start mail session (reason: No > > profile defined) > > 2005-06-30 13:40:30 - + [396] An idle CPU condition has not been defined - > > OnIdle job schedules will have no effect > > 2005-06-30 13:40:30 - + [408] SQL Server MSSQLSERVER is clustered - > > AutoRestart has been disabled > > 2005-06-30 13:51:15 - ! [LOG] The data portion of event 19002 from > > MSSQLSERVER is invalid > > 2005-06-30 16:41:44 - ? [131] SQLSERVERAGENT service stopping due to a > > stop > > request from a user, process, or the OS... > > 2005-06-30 16:41:47 - ? [098] SQLServerAgent terminated (normally) > > > > I can also confirm that the service account used to start SQLServeragent > > is > > the same on both server and the log files are on the share RAID disk. > > > > thanks > > "Geoff N. Hiten" wrote: > > > >> The SQL Server log and the System Event viewer should have detaled > >> reasons > >> why the resource failed to come online. Look there and post what you > >> find. > >> > >> Geoff N. Hiten > >> Microsoft SQL Server MVP > >> > >> "tvq" <tvq@discussions.microsoft.com> wrote in message > >> news:406AB06D-9FF5-4BE6-B760-AE1AAAB94810@microsoft.com... > >> >I have 2 nodes of SQL 2000 Enterprise edition running on 2 windows 2003 > >> > (without terminal server) > >> > When i tried to test the failover by selecting move group from cluster > >> > Admin. Every resources succesfully failed over to the other server > >> > except > >> > SQLServerAgent, it was shown online pending for a while then all the > >> > resource > >> > failed back to the original server. > >> > When I tried to turn off the current primary server and logged on to > >> > the > >> > second server, all the resources have changed to the second server > >> > successfully except SQLServerAgent, its status was shown as failed > >> > Anyone has any ideas please > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |