Installing SQL Server

Overview

This guide will help you install SQL Server, which is required for hosting the server.

Set up involves installing SQL Server, SQL Server Management Studio, and running a "set up" script.

Prerequisites

Refer to this page for SQL Server prerequisites

Refer to this page for SQL Server Management Studio prerequisites

Install SQL Server

Windows users should follow this guide.

Linux users should follow this guide.

Install SQL Server Management Studio

We only officially support using SSMS for working with the database. However, this is only available on Windows at this time. If you're on Linux, we recommend using Data Grip instead.

Windows users should download SSMS from here.

Open SSMS and Connect to Your SQL Server Instance

You will need to enter in the data you set during your SQL Server install. Generally, this is the following:

Server Name: localhost\SQLEXPRESS Authentication: SQL Server Authentication Login: YourUsername Password: YourPassword

Connection issues are outside the scope of this guide so refer to Google if you need help there. If you still can't get it working please contact us on Discord.

Run the database build script

You can find the most up-to-date database script here: https://github.com/zunath/Freescape_JVM/tree/master/nwn/database

The file name is "freescape-db.sql". Simply download this and open it up in SSMS.

This script will create a database named "freescape-db", build all the tables, and insert all of the data.

It can take a few minutes to fully complete, so please be patient. Once complete you should see no errors in the Output tab of SSMS.

OPTIONAL: Remove Player-Generated Data

The script you just ran is built from the production (aka "live") copy of the database. It includes player-generated data like structures, character information, skill levels, and so on.

For testing purposes you don't usually need this data. It doesn't hurt anything to have it but if you'd prefer to wipe it out and start fresh you can optionally run the "WipePlayerData.sql" script found here: https://github.com/zunath/Freescape_JVM/tree/master/nwn/database/scripts

Conclusion

And that's it! Now you're ready to run the server. Refer to this guide on how to do this.