How to Fix SQL Server Agent Not Showing in a Failover Cluster

Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI).

SQL Server Agent not showing in Failover Cluster

If you have a SQL Server failover cluster, and you cannot see SQL Server Agent service in the list of resources, under the relevant SQL Server role in the failover cluster, this most probably indicates, that there is a misconfiguration on the OS-level and/or cluster-level, that prevents the cluster from “seeing” the SQL Server agent service.

In addition to the above, in such scenario, if you right-click on the failover cluster role and select “Add Resource” and then “More Resources”, you will see that “SQL Server Agent” might not be available.

 

How to resolve the issue

So, what do you do in order to resolve the issue?

How can you make the “SQL Server Agent” service available in the failover cluster?

There is a PowerShell command that can help with that, which actually adds as a cluster resource type SQL Server Agent.

This command, is based on the fact that the file “SQAGTRES.dll” exists in c:\windows\system32

Therefore, if indeed the above file is available in the above folder on one of the participating nodes in the failover cluster, then the next step is to run the following PowerShell command:

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

After you run the above command, you can then try again the add the SQL Server Agent service in the SQL Server failover cluster role, by right-clicking and selecting “Add Resource” and then “More Resources”.

 

Learn more SQL Server Administration Tips and Techniques – Enroll to our course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More

 

 

Featured Online Courses:

 

Read Also:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Easily generate snippets with Snippets Generator!

Secure your databases using DBA Security Advisor!

Generate dynamic T-SQL scripts with Dynamic SQL Generator!

Check our latest software releases!

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub