Manually Create the App Server Configuration Database

If you did not create the App Server Configuration Database as part of installing or upgrading your Digitise Apps software, you will need to manually create it and then configure your App Server to point at the database.

A SQL Query, called CreateMxDatabase.SQL, which will create the required database, is copied to your Digitise Apps installation folder, by default:

32-bit Operating Systems:

C:\Program Files\NDL Software\Digitise Apps

64-bit Operating Systems:

C:\Program Files (x86)\NDL Software\Digitise Apps

You can run this query to create the required database, for example within SQL Server Management Studio:

Load SQL Server Management Studio.
Connect to the required SQL Server instance making sure you connect as a user with SQL administrator rights.
Drag and drop the SQL query onto the Management Studio.
Choose Execute from the SQL Editor toolbar.

After creating the database, you then need to enter the connection string in App Manager so that App Server and App Manager can access this database. To do this, you must run App Manager on the same machine as the App Server. For details of how to configure the Configuration Database connection string see Configure Connection Strings for App Server Configuration Database & App Manager.

We recommend that you consider specifying upper and lower limits on SQL Server's memory usage, in particular restricting the maximum amount of memory SQL Server can use - see Microsoft's web site for details: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16.