Shoko Server - Windows Setup

This guide will help you install and perform the initial setup for Shoko Server.

Do I Need To Install Shoko Server?

The short answer is Yes.

Shoko Server is the back-end of the entire Shoko suite, which means every single program and plugin provided uses it for accessing and maintaining your anime collection. This also means Shoko Server must be running to use any of the programs or plugins that connect to it. With the exception of file importing, Shoko Server is no more resource intensive than other programs you probably have running in the background so you don't need to worry about Shoko Server eating up resources.

Selecting A Database Type

The first thing you'll need to do is download Shoko Server, extract it and install it. Administrator rights are required to install and for the initial run, however after that you can run as a normal use.

Once installed, Shoko Server will prompt you to select a Database Type to use for your anime collection, we currently offer three different database options.

Database Setup Type Install / Setup Link
SQLite One-Click Included by default.
MySQL Separate Install Installing MySQL
SQL Server Separate Install Installing SQL Server
Shoko Server - Select Database
Shoko Server - Select Database

Out of the three available database options available, SQLite is the easiest one to install, you simply click Save and Start Server and Shoko Server does the rest. The drawback to using SQLite is it's not designed to properly handle large anime collections that contain over 200 series. While improvements have been made to make SQLite more usable with larger collections, we still recommend using either MySQL or SQL Server.

The remaining two database options, MySQL and SQL Server are both designed to handle and maintain large databases making them ideal if your anime collection currently exceeds 200 series or if you believe it will sometime in the future. Both MySQL and SQL Server have also benefited from the addition of the database cache providing allowing Shoko to access your data faster reducing loading times.

Both MySQL and SQL Server are standalone installs so you'll need to install one of them first if you'd like to use it with Shoko Server. Select Database Setup from the menu on the left for more information on how to install either MySQL or SQL Server.

Once you've installed MySQL, it's time to setup Shoko Server to use it.

From the Database Type drop-down menu select MySQL, you'll be asked to input information related to your MySQL setup.

Option Description
Server Address Only change if MySQL is on a different computer. Default: Localhost
Database Name Only change if you created a custom database for Shoko. Default: ShokoServer
Username If you created an account just for Shoko, use that username. Default: root
Password If you did not create an account just for Soko, its the root password.
Shoko Server - MySQL Database
Shoko Server - MySQL Database

Once you've installed SQL Server, it's time to setup Shoko Server to use it.

From the Database Type drop-down menu select SQL Server, you'll be asked to input information related to your SQL Server setup.

Option Description
Server Address Click the arrow to select an entry from the list.
Database Name Only change if you created a custom database for Shoko. Default: ShokoServer
Username If you created a account just for Shoko, use that username. Default: sa
Password If you did not create an account just for Shoko, its the root password.
Shoko-Server-SQL-Server
Shoko-Server-SQL-Server

If everything was inputted correctly, Shoko Server will connect to SQL Server, create and populate your database.

For compatibility reasons, Shoko Server uses an older version of a Microsoft.SqlServer.SqlClrProvider.dll which can bedownloaded from Microsoft, however we don’t need to install the entire Microsoft SQL Server 2008 Feature Pack, just the following files.

Filename
x64\SQLSysClrTypes.msi
x64\SharedManagementObjects.msi

You may need to try another browser if you are unable to select which files to download. Once you’be downloaded both files installSQLSysClrTypes.msi followed by SharedManagementObjects.msi and then restart Windows.

Shoko Server Installed

Now that you've installed Shoko Server and finished the initial setup, it's time to Configure Shoko Server to start building your anime collection. Using the menu on the left, select Configuring Shoko Server and go through each tab. We recommend starting at the Settings tab.