Setting up a compatible database
To use Innosoft, you need a Microsoft SQL Server. We recommend using a version that is still officially supported by Microsoft. Slightly older versions are usually not a problem. However, since our internal quality assurance takes place on current systems, we can only guarantee the complete functionality of the software with current SQL Server versions.
If you have not already done so, first install Microsoft SQL Server using the installation instructions from Microsoft. You can find these for Microsoft SQL Server 2017, for example here.
Create a new database (e.g.innosoftdb).
Make sure you choose a collation that is case-insensitive.
Create a database user with which Innosoft can authenticate itself to the database in the further course (e.g. innosoftuser).
Assign the db_owner role for the new database to the user.
Make sure that this user has write and read access to both the database schema and the database content.
Furthermore, make sure that the user can authenticate to the server by password. For this purpose, the authentication mode of the SQL server should be set to "Mixed Authentication Mode".
Make sure that the TCP/IP protocol is activated for the SQL Server and note the port on which the SQL Server listens. By default, port 1433 is used.
Once everything is done, you have set up a compatible database for use with Innosoft. It is best to make a note of the following data for later use: Name of the server (and instance name of the Microsoft SQL installation, if applicable), name of the database, created SQL user with password and the port number.