Last updated on 13-May-2020 by Thomas P. Boesen

Thomas P. Boesen

Founder
boesen@scifeon.com

Make sure your system fulfill the requirements before proceeding with configuration of the server.

The following steps ensure that Internet Information Services (IIS) and SQL Server are correctly setup. Login to the Windows Server 2016 with an Administrator account and follow these steps:

Step 1: Enable IIS

1. Open Server Manager and open the Add Roles and Features wizard.
2. Click Server Roles (you might need to click Server Selection first), check the box for Web Server (IIS) and click Next.
3. If you need to enable Windows Authentication, navigate to the Web Server (IIS) > Web Server > Security and check Window Authentication.
4. Click Next on Role Services and click Finish on the Confirmation step.

Step 2: Install the .NET Core Windows Server Hosting bundle

1. If the server doesn't have an internet connection, download and install the Microsoft Visual C++ 2015 Redistributable before proceeding.
2. Download the .NET Core Windows Server Hosting bundle.
3. Install the bundle on the server.
4. Restart the system or execute net stop was /y followed by net start w3svc

More detailed description of the above can be found at Microsoft Docs.

Step 3: Install and configure SQL Server 2016

We do not provide instructions on installing SQL Server 2016.

The only configuration needed is enabling Mixed Mode authentication.

Step 4: Create database on SQL Server 2016

First the database for Scifeon is created. We recommend to use Microsoft SQL Server Management Studio (SSMS) for managing your SQL Server. Follow these steps to create the database using SSMS:

1. Login as a System Administrator.
2. Right-click Databases and click New Database.
3. Enter an appropriate name in the Name field.
4. Select the Options on the left, and choose SQL_Latin1_General_CP1_CI_AS in Collation:

   

5. Click OK.

A more detailed guide can be found here: Microsoft Docs: Create a Database using SQL Server Management Studio

Alternatively, execute the following SQL script on your master database: prerequisites

USE master;  
GO  
CREATE DATABASE <database_name>
COLLATE SQL_Latin1_General_CP1_CI_AS;  
GO  

Step 5: Create users in database

Scifeon needs two users: a user with read and write access to tables, and a user with privileges to create and alter tables, views and triggers.

Execute the following on the master database to create logins for the users:

-- Read/write user
CREATE LOGIN <username> WITH PASSWORD = '<strong password>'
GO
-- Read/write/create/alter user
CREATE LOGIN <username_ddl> WITH PASSWORD = '<another strong password>'
GO

Store the usernames <username> and <username_ddl> and passwords appropriately for later use.

Execute the following on the database created in the previous step:

-- Create schema for audit tables
CREATE SCHEMA Audit
GO
-- Read/write user
CREATE USER <username>
  FOR LOGIN <username>
  WITH DEFAULT_SCHEMA = dbo
GO
GRANT INSERT ON SCHEMA :: Audit TO <username>
GO
GRANT INSERT, UPDATE, DELETE, SELECT ON SCHEMA :: dbo TO <username>;
GO
-- Read/write/create/alter user
CREATE USER <username_ddl>
  FOR LOGIN <username_ddl>
  WITH DEFAULT_SCHEMA = dbo
GO
EXEC sp_addrolemember N'db_datareader', N'<username_ddl>'
GO
EXEC sp_addrolemember N'db_datawriter', N'<username_ddl>'
GO
EXEC sp_addrolemember N'db_ddladmin', N'<username_ddl>'
GO

You have now prepared your server and database for installation of Scifeon.