Prerequisites for SQL Server without data replication

You can set up a failover cluster with an external SQL Server instance not running on the nodes. With this configuration, XProtect Management Server Failover does not monitor the SQL Server databases.

Note

The failover server configuration with external SQL Server does not work in a workgroup environment.

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:

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.

XProtect Management Server Failover

Prerequisites for SQL Server without data replication

Note

Search results