Configuring SQL Server

Installing and setting up SQL Server for use with Shoko Server.

Why SQL Server Over SQLite

SQL Server is an advanced database option that allows users to further fine-tune their database to achieve quicker response times. Most users will not benefit from installing SQL Server so we recommend using SQLite or MySQL.

Download

SQL Server is available in many different versions and while you can use any version you'd like, for Shoko Server we recommend downloading SQL Server 2016 Express which is free to download.

If you decide to use an older version, there may be additional steps required that are not covered on this page. If this is the case and you need help, click the Support link in the top-right.

Installing SQL Server Community Server

Start the installer, since Microsoft only provides the web-installer you'll have to download SQL Server Express 2016 before you can install it.

Once the web installer is loaded, select Custom for the Install Type.

SQL Server - Select Install Type
SQL Server Install - Select Custom

You'll be then asked to select the Download Location, this is not the same as the Install Location you can change later on.

We recommend selecting a temporary location as you can delete these files after you've installed SQL Server.

SQL Server - Select Download Location
SQL Server - Select Download Location

The download can take awhile depending on the speed of your internet connection, you don't need to watch it download as the install will automatically start once the download has finished.

SQL Server - Downloading
SQL Server - Downloading

From the list of options select New SQL server standalone installation, if you already have SQL Server installed you can upgrade it instead. The installer will then check for any setup dependencies. If you receive any errors you’ll need to fix them before you’re able to continue on, otherwise click OK to proceed with the install.

Proceed past the License Terms section which contains your standard information about the license for using SQL Server 2016.

SQL Server - Install Start
SQL Server - Install Start

We recommend allowing Microsoft to update SQL Server so you always have the latest version. Unless something major is changed, updates to SQL Server 2016 should not cause issues with Shoko Server. 

Proceed with the install, depending on what needs to be installed and your environment this might take awhile.

SQL Server - Allow Automatic Updates
SQL Server - Allow Automatic Updates

After it's done installing, you'll be shown a list of the Install Rules and their statuses.

Install rules that have failed will need to be corrected before you can move on, install rules that are warnings should be looked into as they might cause an issue down the line.

After you're done it's time to configure SQL Server.

SQL Server - Install Rules
SQL Server - Install Rules

Configuring SQL Server 2016

In the Feature Section you’ll be presented with a list of options to select, for Shoko you only need to check the following.

  • Database Engine Service
  • SQL Server Replication
  • Full Text and Semantic Extractions For Search
  • Client Tools for Connectivity
  • Documentation Components

Click Next to continue and keep going until you come to the Instance Configuration section

SQL Server - Feature Selection
SQL Server - Feature Selection

We recommend selecting Default Instance instead of Named Instance to avoid an potential issues down the road. Advanced users who want to run multiple instances of SQL Server can select Named Instance but should know what they are doing.

Once down click Next to be taken to the Server Configuration window.

SQL Server - Instance Configuration
SQL Server - Instance Configuration

n the Server Configuration section make sure each service has it’s Startup Type set to Automatic. 

You need SQL Server to start with Windows so Shoko can access your collection, otherwise you'll need to manually start SQL Server every time you want to run Shoko Server.

Once down click Next to be taken to the Database Engine Configuration window.

SQL Server - Server Configuration
SQL Server - Server Configuration

The Database Engine Configuration section is where you’ll be setting up the Administrator account for SQL Server 2016.

First make sure Mixed Mode is selected and enter a password you want to use. The username for this account is simply sa and it’s what we’ll be using in Shoko Server.

Before continuing on click on Add Current User to add your account to the list of accounts which can access SQL Server 2016.

Once down click Next to be taken to the Complete window.

SQL Server - Database Engine Configuration
SQL Server - Database Engine Configuration

You’ll now see the summary of your SQL Server 2016 install.Review the list of Features and make sure each item is listed as Succeeded, if any are not you’ll need to fix them.

With that SQL Server 2016 has been successfully installed! If you’ve paused your Shoko Setup, you can now continue with the install.

SQL Server - Install Complete
SQL Server - Install Complete