SQL cluster nodes do not reconnect sometimes #5218
Description
Description of Issue
The PSU environment is 2 nodes (5.6.4) using a central SQL DB as backend. The SQL DB used is an Always-On Cluster (Active-Active) backed with two SQL instances/Servers. When the switch of the cluster occurs, there is a 2-3 second gap of loss of connectivity. PSU does not recover from this and the only recourse is to reboot the nodes.
Version
5.6.4
Severity
Medium
Hosting Method
MSI (Windows Service)
Operating System
Windows
Database
SQL
Licensed
Yes
Features
No response
Additional Environment data
Microsoft SQL Server 2022 (RTM-CU20-GDR) (KB5063814) - 16.0.4210.1 (X64) Jul 11 2025 13:04:02 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Standard 10.0 (Build 20348: ) (Hypervisor)
Screenshots/Animations
No response