Hello, I am new to SQL Server clustering. I have a SQLServer2005 active-passive cluster and both SQL service and SQL Agent service are cluster resources. What is the correct way to restart SQL Agent service? - Using SQL Configuration Manager and restart SQL Agent service - Using Cluster Admin, right click SQL Agent --> Take offline --> Bring Online - Go to services panel of Active node and restart SQL Agent service Thank you, SQL Novice
You don't need to be so worried about starting the SQL Agent service because it's a node of a Cluster. You can start it using services MMC or Configuration Manager or SSMS or from Command Prompt... -- Ekrem Önsoy "msnews.microsoft.com" wrote in message news:eCqCd93JJHA.3764@TK2MSFTNGP04.phx.gbl... > Hello, > > I am new to SQL Server clustering. > > I have a SQLServer2005 active-passive cluster and both SQL service and SQL > Agent service are cluster resources. What is the correct way to restart > SQL Agent service? > > - Using SQL Configuration Manager and restart SQL Agent service > - Using Cluster Admin, right click SQL Agent --> Take offline --> Bring > Online > - Go to services panel of Active node and restart SQL Agent service > > > Thank you, > SQL Novice >
Thanks Ekrem. My colleague mentioned that any cluster resource has to be restarted only through the Cluster Admin. I couldn't find any documentation supporting or denying that. Hence my question. "Ekrem Önsoy" wrote in message news:B893F3D6-3CD2-4213-B29F-64DCFF1053BF@microsoft.com... > You don't need to be so worried about starting the SQL Agent service > because it's a node of a Cluster. You can start it using services MMC or > Configuration Manager or SSMS or from Command Prompt... > > -- > Ekrem Önsoy > > > > > "msnews.microsoft.com" wrote in message > news:eCqCd93JJHA.3764@TK2MSFTNGP04.phx.gbl... >> Hello, >> >> I am new to SQL Server clustering. >> >> I have a SQLServer2005 active-passive cluster and both SQL service and >> SQL Agent service are cluster resources. What is the correct way to >> restart SQL Agent service? >> >> - Using SQL Configuration Manager and restart SQL Agent service >> - Using Cluster Admin, right click SQL Agent --> Take offline --> Bring >> Online >> - Go to services panel of Active node and restart SQL Agent service >> >> >> Thank you, >> SQL Novice >> >
