Cluster error

Dario Bodini 1 Reputation point
2024-07-17T15:53:45.3366667+00:00

Cluster with Alwayson unreachable:

Errors:

00000ef4.00000a74::2024/07/17-13:51:50.791 ERR [API] AccessCheck[AndAuditAlarm] failed. status = 0x00000005

00000ef4.00000a74::2024/07/17-13:51:53.512 WARN [API] s_ApiOpenResourceEx: Resource Scaleout Master not found, status = 5007

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,318 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,595 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
978 questions
{count} votes

3 answers

Sort by: Most helpful
  1. LucyChenMSFT-4874 2,985 Reputation points
    2024-07-18T01:44:45.5633333+00:00

    Hi @Dario Bodini ,

    Thank you for your reaching out and welcome to Microsoft Q&A!

    Please refer to this article, you can follow the steps to troubleshoot the issue. It may not be comprehensive. Could you please provide the detailed logs here to help us narrow down the issue? We need more information to locate the issue!

    Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

    Best regards,

    Lucy Chen


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications


  2. Dario Bodini 1 Reputation point
    2024-07-18T07:51:26.07+00:00

    Dear @LucyChenMSFT-4874 ,

    the article is not comprehensive, you're right.

    Below attached advanced debug log files from both cluster nodes.

    Regards

    Dario

    SQLTST-DC_cluster.log

    SQLTST-BC_cluster.log

    0 comments No comments

  3. LucyChenMSFT-4874 2,985 Reputation points
    2024-07-19T06:32:36.9366667+00:00

    Hi @Dario Bodini ,

    Thank you for your kindly feedback!

    I've checked the logs you provided. I searched for situations similar to your issue and made the following summary. You can according to the suggestions below to troubleshoot your issue!

    • It seems that all non-english operating systems are affected. Please refer to this thread and try to rename the ClusterResource if your system is like what he said.
    • Here is an issue like yours, you can check out the answer in it.
    • Some error messages in your logs make me confused. I think maybe some faults are beyond this SQL Server thread, I can only offer you support in SQL Server. You can add the tag Windows-Server-Clustering to the thread to get more help.

    Feel free to share your issues here if you have any concerns.

    Best regards,

    Lucy Chen


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

    0 comments No comments