This page supports you in installation and configuration of a database management (DBMS) system that can be used by InnoList.
The installation and execution of MySQL and MariaDB is very similar. Because if this the two database types are handled combined here.
You can download the databases as zip-files or as setup packages. Also a execution as a service is possible.
As soon as MySQL/MariaDB is running, continue with the creation of a database.
Download PostgreSQL: https://www.postgresql.org
During the installation/configuration you decide:
Notice: The starting of PostgreSQL can fail if the data directory is located inside a user profile directory of the operating system. PostgreSQL might use another user to run and because of this it might not be able to access the directory of another user.
Notice: You should consider to create backups of the database regularly.
PostgreSQL can be executed as a service in Microsoft Windows.
Configure PostgreSQL using pgAdmin
If PostgreSQL is executed, pgAdmin (https://www.pgadmin.org) is a very helpful Management Tool for the next steps.
By creating the database the configuration of PostgreSQL is finished.
as set in the configuration process.
InnoList creates some tables in the new database in PostgreSQL. Only one application in InnoList can be changed to connect to a specific database in PostgreSQL, repeating attempts to do this will fail.
The support for Microsoft SQL Server will end soon. Please do not use this database management system any more and switch to an alternative provider.
(if you do not have Microsoft SQL Server available, Microsoft offers a free version with the name SQL Server Express)
Services For Microsoft SQL Server
To enabled the access beside the SQL Server service also the service SQL Server Browser needs to be started.
Important: Microsoft SQL Server needs to be configured to accept connections via TCP/IP.
More information on this topic (at Microsoft.com):
As soon as Microsoft SQL Server is running and configured, continue with the creation of a database.