Introduction

In this guide, you will install the SQL database, which stores all operational and historical data for your System Frontier instance.

System Requirements

	Recommended	Minimum
Server OS:	Windows Server 2025	Windows Server 2019
Cores / vCores:	4	2
Memory:	16 GB	8 GB
Disk space:	80 GB	20 GB
SQL Version:	Microsoft SQL Server 2025 (any edition)	Microsoft SQL Server 2019 (any edition)

Getting Ready

Please perform the following tasks before starting the install.

• Download the latest setup zip file from your account page.
• Have your System Frontier license key file ready.

Important: Have a DBA or someone with sysadmin rights on the SQL server perform the following two steps.

• Create an empty database with the name SystemFrontierV2, or one of your choosing.
• Create a SQL login and grant it db_owner on the database.

Installation steps

1. The database installation can be run from any computer that has network access to the database server.
2. Extract the setup zip file.
3. Run the setup-database.exe file.
   
4. Accept the license terms and conditions, then click Next.
5. Provide the SQL server hostname in the Server textbox. If an instance name is needed, you’ll need to include that as well. Examples:
   • Default instance: docs-dbs01
   • Named instance: docs-dbs01\SQLExpress
     
6. Leave the Port textbox empty unless you are using a port other than 1433.
7. In the Database textbox, provide the name of the System Frontier database. Example: SystemFrontierV2
8. Provide the SQL login and password that were created and mapped to the SystemFrontierV2 database.
   _{Note: System Frontier uses SQL authentication to connect to the database, so this will not be a domain or Windows login.}
9. Click Test to verify the connection and credentials to the database.
10. Once the test is successful, click Next.
    
11. By default, the current user will be set up as the first administrator in System Frontier. If that should be someone else, please provide their domain\username instead.
    _{Note: While this field does not accept a group name, you can add Active Directory groups to roles once the application is fully online.}
    
12. Click Next.
13. Click the button with three dots to browse and select your license file.
    
14. Click Validate.
15. Once your license file is validated, click Install.
16. Once the install is successful, click Finish.
    

Next Steps

Once the database setup has been completed, you’ll want to install the execution host service, then web app.