Installation of the database

DiversityCollection uses Microsoft SQL-Server 2014 or later as database engine. If you do not have a database server with DiversityCollection already available, you need to install the database engine first. Download the free version of Microsoft SQL Server Express 2014 or later from Microsoft. Start the program and follow the instructions for the installation.

To create a new database see the chapter Database creation.


Server configuration

To configure your server for remote access launch the SQL Server Configuration Manager (see image below).

Then click on the "Protocols for SQLEXPRESS" node. Right click on "TCP/IP" in the list of Protocols and choose "enable" for TCP/IP.

Right click on the TCP/IP node and select "Properties" to open a window as shown below.

In the part IPALL clear out the value for "TCP Dynamic Ports". Give a TCP-Port number to use when making remote connections e.g. "4321" as shown above. You have to restart the SQL Server Express service before you can connect to your database. 

If you use a database on a server, make sure that the firewall of the server allows access via the port you set for the connection (see below). 

Start the Microsoft SQL Server Managment Studio and attach the database as shown below. Choose the node "databases" and right-click on it to open the context menu (see below). Then choose "attach" from the context menu. A window will open where you can choose the file DiversityCollection_Data.MDF from your database directory and attach it to the database engine.

If you get a message as shown below, the version of your SQL-Server database engine is older than the one for the creation of the database you selected for a download. Please return to the download site and select an older version of the database, compatible with the version of your server.


After the installation make sure to get the latest updates from m/.


Database configuration

To configure your database use the client as described in Database configuration.