SQL Server Agent not listed as cluster resource

Question

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.

Mike

Answer 1

Try to add custom service to cluster resource and choose SQL Agent.

Answer 2

Please post the exact error message you are receiving on the SQL Server Errorlog / Agent Log / Event viewer.

SQL Server Agent will be part of the SQL Server installation and it will be by default would appear on the Cluster Manager.

 

---

Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!

Answer 3

The SQL agent is missing because the setup never finished successfully.

At this point you should 

1 - Add the SQL agent 'resource type'.

cluster restype "SQL Server Agent" /create /DLL:sqagtres.dll

2- Add the SQL agent resource ..

.       In the Failover Cluster Management use Add Resource to add the SQL Server Agent resource.
Name the resource as “SQL Server Agent”, as this is case sensitive unless you are on CU3 or above for SQL Server 2008 RTM.

a.       Right-click on the SQL Agent resource and go to Properties and fill in values for the two parameters.
b.      Specify the Virtual Server name of the SQL instance.
c.       Specify the Instance name.
d.      Add the SQL Server Resource as a dependency for the newly created SQL Server Agent resource

3.       Open Registry Editor and browse to the following location.

Default Instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState

Named Instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.INSTNAME\ConfigurationState

Make sure that the values for all the keys present are 1. In case it is not, change it to 1.
This will set the configuration state for all SQL features to 1, meaning the feature is installed and configured. A value greater than 1 indicates either an install failure or configuration failure.

4- perform a repair of the instance.

How to: Repair a Failed SQL Server 2008 Installation
http://msdn.microsoft.com/en-us/library/cc646006.aspx

just fyi there is a KB coming for this.

thx-vijay

Answer 4

and Yes one last thing .. change the dependencies if any and delete the generic resource that you created for sql agent.

Answer 5

Perfect, thanks much for the help everyone.

Answer 6

I am having the same issue and have followed the same instructions but was never as lucky as you

I am running SQL Server Agent as a generic service not as a SQL Server Agent cluster resource service

 

Any advise

Answer 7

The above solution will work.

First delete the generic resource that you have created and then follow the solution provided above.

thx-vijay

 

Answer 8

When trying to run:

cluster restype "SQL Server Agent" /create /DLL:sqagtres.dll

I'm getting the following error message: Cannot create a file when that file already exists. I've ensured this resource does not exist in my default instance cluster group.

Any help would be appreciated!

Answer 9

There are two things

1. ResourceType

2. Resource

The command above creates a resourcetype for SQL agent. Confirm it by running below command

Cluster Restype

 

---

Thanks - Vijay Sirohi

Answer 10

This seems to have worked for me as well. When can we expect the KB for this? 

Answer 11

thank you so much!  this worked wonderfully. 

Answer 12

The KB was published some time back -- http://support.microsoft.com/kb/2102055

 

---

Thanks - Vijay Sirohi

Answer 13

The KB was published some time back -- http://support.microsoft.com/kb/2102055

 

---

Thanks - Vijay Sirohi

Hi Vijay,

 

Thank you so much! this information helped me to finish my cluster configuration!

Answer 14

The solution of adding the resource type, then adding the resource makes sense, but I get "Access Denid" when I try to run the "cluster restype" command, even with no parameters.

I'm a local system admin...weird.

Answer 15

When launching CMD - choose 'Run as Admin'

that will get you working.

 

---

Thanks - Vijay Sirohi

Answer 16

In my case this happened because I forgot to put the "FAILOVERCLUSTERIPADDRESSES" in my configuration.ini file. After I added this parameter AND removed the DNS record from the dns server, I was able to install all resources.

---

Warjte31

Answer 17

Thanks for posting this, it resoved an issue I was having with sql agent on my 2008 cluster.

Answer 18

Hi Vijay,

I have similar issues but different version such as Windows 2012R2 cluster with SQL2012SP2.

I am using Windows PowerShell to perform the following,

1. Import-Module FailoverClusters

2. Add-ClusterResourceType "SQL Server Agent" c:\windows\system32\SQAGTRES.DLL

Error: Add-ClusterResourceType : Unable to locate the cluster service executable on node1

The network name cannot be found.

No problem to ping all cluster related names as well as fail-over to and from next available node.

Please advice. Thanks.

---

Kelvin Teang

Answer 19

Hi Vijay,

Thanks for this excellent article. 

Answer 20

Work for me : perfect.

Thank you, i have not reinstalled the istance !

---

Hunternet

Answer 21

follow this

https://virtualhobbit.com/2015/09/23/wednesday-tidbit-adding-the-sql-server-agent-to-a-windows-failover-cluster/

---

Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)