SQL Cluster resource fails to come online

  • Article

You have a SQL clustered resource and it's failing to come online as a clustered resource. When you look at the SQL Server error log we can see that SQL is starting and all the DB's are also starting however, SQL is shutting down without any error messages. This is because cluster service is taking it down as not able to connect to SQL Server to confirm that the resource is up and running.

When you look at the cluster log by generating it using PowerShell command get-clusterlog we see the following in the cluster logs :

 

00000e30.00003700::2015/04/09-00:30:14.994 ERR   [RES] SQL Server <SQL Server (Dist)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].  (268435455)
00000e30.00003700::2015/04/09-00:30:14.994 ERR   [RES] SQL Server <SQL Server (Dist)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00000e30.00003700::2015/04/09-00:30:14.994 ERR   [RES] SQL Server <SQL Server (Dist)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (268435455)
00000e30.00003700::2015/04/09-00:30:14.994 ERR   [RES] SQL Server <SQL Server (Dist)>: [sqsrvres] ODBC Error: [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)
00001548.000024a0::2015/04/09-00:30:15.384 ERR   [RES] SQL Server <SQL Server (ware)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].  (268435455)
00001548.000024a0::2015/04/09-00:30:15.384 ERR   [RES] SQL Server <SQL Server (ware)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001548.000024a0::2015/04/09-00:30:15.384 ERR   [RES] SQL Server <SQL Server (ware)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (268435455)
00001548.000024a0::2015/04/09-00:30:15.384 ERR   [RES] SQL Server <SQL Server (ware)>: [sqsrvres] ODBC Error: [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)

 

From the above error message it's very clear that we are not able to make a connection to SQL instance on the local node. Also when we check the port on which SQL is listening, than it's a non-default port and not listening on 1433. Since it's not listening on the default port so we have to make sure that SQL Browser service is running and the UDP port 1434 is not blocked in the windows firewall. If due to security limitations we can't run SQL Browser service than we can create an alias on the local node to help cluster service connect to the SQL server.
 

 

Happy Learning & Troubleshooting!!

 

Disclaimer:  Everything here, is my personal opinion and is not read or approved by Microsoft before it is posted. No warranties or other guarantees will be offered as to the quality of the opinions or anything else offered here.