SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check

This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. 

While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If we check Detail.txt file in setup logs, we will find below.

Read More

SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)

Sometimes DBAs get into a situation where they don’t know what the next steps is to fix the issue. Here is one of the situation where DBA contacted me with below error in installing a patch for SQL Server in clustered environment. If you don’t know then I can tell you that I do provide quick consultancy. You can read more here On Demand (55 minutes). In this blog post we will learn about how to fix an installation error. 

Read More

SQL SERVER – SQL Service Not Starting in Cluster- The System Cannot Find the File Specified

Sometimes there are various issues with the operating system and disk which would cause an issue with SQL Server. In this blog, I am going to share a recent troubleshooting done for one of my clients. Let us see the solution to fix the issue of SQL Service not starting in a cluster.

Read More

SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource

In my lab setup, I already have a 2 node windows 2012 R2 cluster. I already had one SQL server 2012 instance is working fine without issues. However, when I was trying to install a new additional SQL 2012 instance, the installation reached till the last phase and getting failed with errors related to a cluster resource. 

Read More