View the instance name of the SQL Server
Milestone recommends that you check the SQL Server instance name before you start the configuration of the failover cluster.
XProtect Management Server Failover uses a hardcoded name for the SQL Server instance name MSSQLSERVER when the SQL Server is part of the failover cluster.
If the instance name is not MSSQLSERVER, the configuration will fail.
-
Open the Start menu, and enter services.msc to open Services.
-
Scroll down to SQL Server [Display name].
-
Right-click the service and select Properties. On the General tab, the value in the Service name field is the instance name.
If the instance name is not MSSQLSERVER, see https://supportcommunity.milestonesys.com/s/article/Management-Server-Failover-Configuration-fails-if-SQL-is-installed-separately-troubleshooting.