Configuring the failover cluster without database replication

You exclude the SQL Server databases from data replication by connecting to a SQL Server instance hosted on your network.

Prerequisite	Description
Permissions for the SQL Server user	In Microsoft SQL Server Management Studio, add a Windows user to the public role and map the user to the db_owner database role for the following databases: Surveillance Surveillance_IDP Surveillance_IM
Connection	Verify that the VMS installations on both nodes: Are connected to the external SQL Server instance. The VideoOS IIS application pools on Node 1 are running. The VMS services on Node 1 are running.
Service account	Make sure that the Management Server service on both nodes runs under the Windows user you added on the SQL Server computer. If your SQL Server runs under a different user, you can change the account that runs the Management Server service. See Changing the service account that runs a VMS service.

Prerequisite

Description

Permissions for the SQL Server user

Connection

Verify that the VMS installations on both nodes:

Service account

Make sure that the Management Server service on both nodes runs under the Windows user you added on the SQL Server computer.

If your SQL Server runs under a different user, you can change the account that runs the Management Server service. See Changing the service account that runs a VMS service.

To configure the failover cluster, you switch between Node 1 and Node 2 in the following order:

During the configuration, the XProtect VMS users won't be able to log in to any XProtect client during configuration.

XProtect Management Server Failover