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.
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
SQL Server Version
This guide is based on SQL Server 2016 Express.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
Help Make This Page Better
Have an idea to improve this page? Is the material incorrect or outdated? Don't wait for us to notice it and update it, instead make the update yourself so the community can benefit from it.Installing and Setting Up SQL Server on GitHub