Scolo currently only supports database types for MySQL and SQL Server. Either storage engine is essentially the same to the application and the merits of using one over the other is left up to the you the end user to decide what fits into your IT infrastructure best. MySQL is available for many different operating system platforms and SQL Server Express is only for the Microsoft Windows platforms. Free versions of each are available for download as well as paid versions with support from the developers or third party vendors.

At the time of writing this document, here are links to the free versions of the databases. MariaDB is a forked development project of MySQL that seamlessly works with Scolo's MySQL logic at this time. There are no guarantees that this will always be the case.

You need to set up a new empty database for Scolo prior to being able to successfully run the application. While the database you create will be empty it will need to have a service type account for Scolo to connect with. The permissions of this service account needs to have the ability to create tables and procedures, insert, update and delete records, execute and alter procedures, and create temporary tables.

This service account should be used for all installed instances of Scolo regardless of what type of user you are installing it for. The account credentials are initially entered once per installation as an administrator on the workstation. The service account login credentials are saved locally in an encrypted form so you do not have to worry about the service account being comprised.

The service account should not be confused with individual user credentials for Scolo. The user accounts are created inside the application which controls what the user is able to do. The user accounts are setup after logging in the first time as the administrator.

The first time Scolo connects to the empty database that has been created for it, all the required tables and procedures are created.

This is not intended to be any type of in depth instructional document of database configuration and administration. Instead it is intended to help you quickly get a working system up and running without any problems if your knowledge of these databases is limited. If you wish find more information regarding tuning and administering your database instance, there is a wealth of information on the database developer’s and other websites.

While setting up a working database is not be a daunting task, there are many nuances to configuring and running individual instances for the best performance and security.

Scolo does not require any drivers for connecting with the databases. All Scolo needs to know is what type of database it is talking to, the name or IP address of the database server and account credentials to log into the database.

Scolo currently supports two database types, MySQL and SQL Server. There are free versions of each available as well as paid versions with support services. MariaDB is a forked development project of MySQL that seamlessly works with Scolo's MySQL logic at this time. There are no guarantees that this will always be the case.

At the time of writing this document, here are links to the free versions of the databases.