Hello everyone, thanks for any help on this issue. I have recently installed SQL 2008 R2 on a Server 2008 R2 machine cluster. We ran the advanced cluster prep and completion. I have SQL Server up and running properly and failing over between
nodes. In the failover cluster manager, when I select SQL Server, I do not have the SQL Server Agent listed under other resources. When I try to start the Agent from the SQL Configuration Manager it fails with an event 103 and I've found several
notes on this error but I am figuring the root issue is that there isn't a cluster resource for the Agent.
Is it possible to create the resource for the Agent? I have run a repair and I have tried to use add a resource, generic service, sql agent but it fails when I attempt to bring it online.
Thanks again for any help on this.
View Complete Post