Determine SQL server type

The Microsoft SQL Server Express Edition is a "lightweight" version of a full SQL server. It is easy to install and prepare for use, and is often a good choice for systems with less than 300 cameras. This version of the SQL Server is included in the Single Computer installation.

For large installations with more than 300 cameras, Milestone recommends that you use a dedicated existing SQL server on a dedicated computer on the network. You must have administrator rights on the SQL server.

Milestone recommends that you install the database on a dedicated hard disk drive that is not used for other purposes. Installing the database on its own drive improves the entire system performance.

When you select Distributed or Custom as part of the installation wizard, you must decide what to do regarding the SQL server.

If you do not have a SQL server installed, the options are:

Install SQL Server Express on this computer.
Use an existing SQL Server on the network: If your system uses a dedicated computer for the SQL database, the list of SQL servers that your account can access appears.

If you have a SQL server installed, the options are:

Use the installed Microsoft SQL Server Express database on this computer.
Use an existing SQL Server on the network: When you use a dedicated computer for the SQL database on the network, the list of SQL servers that your account can access appears.
You are also asked whether you want to create a new database, use an existing database, or overwrite an existing database.
- Create new database: For a new installation.
- Use existing database: If you are installing the database as part of an upgrade of the system, and you want to use your existing database.