Loading ...
Loading ...
Loading ...
Managing the SQL Server and databases
Changing the SQL Server and database addresses (explained)
When you install a system as a trial, or if you restructure a large installation, you may need to use a different
SQL Server and database.
You can change the address of the SQL Server and database used by the management server and by the event
server, and the address of the SQL Server and database used by the log server, the XProtect Incident Manager
server and the IDP server. The only limitation is that you cannot change the management server and the event
server's SQL addresses at the same time as the log server's SQL address. You can do it one after another.
You must change the SQL Server and database addresses locally on the computers where you have installed
the servers. If your management server and event server are installed on separate computers, you must
update the addresses on both computers.
You must copy the SQL databases before you proceed.
Change the log server's SQL Server and database
To change the SQL location for the Log Server, do the following:
Before making any changes to the registry, make a registry backup.
1. Ensure that the user running the Log Server application pool is the owner (DBO) of the log server
database.
2. Update the ConnectionString value in the Windows Registry to include the new location and name of
the log server. The value can be found and modified under:
HKEY_LOCAL_MACHINE\SOFTWARE\VideoOS\Server\ConnectionString:
3. Restart the Log Server via Windows Services.
The default database name is: SurveillanceLogServerV2.
Change the management server and the event server's SQL Server and
database
To change the SQL location for the management server and the event server, do the following:
Before making any changes to the registry, make a registry backup.
Administrator manual | XProtect® VMS 2023 R1
331 | Maintenance
Loading ...
Loading ...
Loading ...