Re: Unable to run SQL agent after failover

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All services should be in MANUAL startup in a cluster. That allows the
cluster service to control service startup.

The SQL tools installer is not cluster-aware. You must manually install the
tools to each cluster node.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"stephanie" <stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BB5B7C9-1E92-4AD0-852C-EFAC4FAAC7E3@xxxxxxxxxxxxxxxx
Hi all,
I failed failover to a secondary node and found that the sql agent was
'disabled' in the secondary node. However, in cluster admin and SQL
Server
configuration Manager, it shows the SQL Agent is running. Also, there is
no
error message in event viewer. BTW, I can't found the management studio
icon in secondary node..

Any idea? Thanks in advance!


.

Relevant Pages

  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... Senior SQL Infrastructure Consultant ... SAN/Smart array or through a fibre channel switch. ... The SAN or Smart array will dictate what internal connection the disks ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... You could make a test environnement through Virtual Machine to get a picture on Cluster. ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL server 2005 SP2 failing on cluster
    ... We have been told for a long time that MSDTC is optional on a cluster but is all but required in the real world. ... I'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster group and group 0
    ... If you take a node offline, all resource groups hosted on it will fail over. ... As for your SQL 2005 cluster, if the node being upgraded goes offline during ... SQL Virtual Server name to connect to the SQL instance. ...
    (microsoft.public.sqlserver.clustering)