Database Creation #

1. Have your DBA create a new database on SQL Server. For this guide, we will use FRIENDSHIP_V2 as the database name.

Create SQL Login #

1. Open SSMS and create a new SQL login. Name it SF_SQL_ADMIN.
2. Ensure this is a SQL account, not a Windows or Active Directory account.
3. Map this new service account to the System Frontier database and assign it the DB_OWNER role to grant necessary permissions for table creation and database management from the web application.

Prepare for Installation #

1. Ensure the System Frontier license key is handy.

Run Database Installer #

1. Start the System Frontier database installer.
2. Read and accept the System Frontier EULA.
3. Enter the Database server name. If using the main instance with SQL Express, input it as SERVERNAME\SQL_EXPRESS.
4. Enter the service account name (SF_SQL_ADMIN) and password.
5. Click Test to verify the credentials and database information. Confirm success before proceeding.
6. Click Next.

Administrator Configuration #

1. By default, the current user’s domain and username will be populated. This user will be the first administrator with access to System Frontier after installation.
2. If a SQL DBA is running the installer, input the actual administrator’s account to administer the app post-installation.
3. Click Next.

License File Validation #

1. Select your license file.
2. Click Validate to ensure the license key is valid.
3. Click Install.

Finalize Installation #

1. The installer will connect to the database using the provided credentials, set up tables, and initialize necessary data.
2. Once the installation is complete, you will see a confirmation message.
3. The database installation is now finished.