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 do this with the Update SQL Server Address tool.

With the tool, 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 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 addresses. 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 management server, the event server and the log server. If your management server and event server are installed on separate computers, you must run the Update SQL Server Address tool on both computers.

You must copy the SQL databases before you proceed.

Change the log server's SQL Server and database

  1. Go to the computer where your management server is installed and copy the folder %ProgramFiles%\Milestone\XProtect Management Server\Tools\ChangeSqlAddress\ (with content) to a temporary folder on the event server.
  2. Paste the folder that you copied to a temporary place on the computer where the log server is installed and run the included file: VideoOS.Server.ChangeSqlAddress.exe. The Update SQL Server Address dialog box appears.
  3. Select Log Server and click Next.
  4. Enter or select the new SQL Server and click Next.
  5. Select the new SQL database and click Select.
  6. Wait while the address change takes place. Click OK to confirm.

Change the management server and event server's SQL addresses

The management server and event server uses the same SQL database.

  1. If your management server and event server are located:
    1. together on the same computer and you want to update the SQL addresses, go to the computer where your management server is installed.
    2. on different computers and you want to update the management server's SQL address (and later the event server SQL address), go to the computer where your management server is installed.
    3. on different computers and you want to update the event server SQL address only (or you have already updated it on the management server), go to the computer where your management server is installed and copy the directory %ProgramFiles%\Milestone\XProtect Management Server\Tools\ChangeSqlAddress\ (with content) to temporary directory on the event server.
  2. If you choose:
    1. steps 1.1 and 1.2, go to the notification area of the taskbar. Right-click the Management Server icon, select Update SQL address. Repeat the process to update the event server SQL address.
    2. step 1.3, paste the directory you copied to a temporary place on the computer where the event server is installed and run the included file:VideoOS.Server.ChangeSqlAddress.exe.
  3. The Update SQL Server Address dialog box appears. Select Management Server services and click Next.
  4. Enter or select the new SQL Server and click Next.
  5. Select the new SQL database and click Select.
  6. Wait while the address change takes place. When a confirmation message is presented, click OK.