LAST UPDATED: 27th June 2023

Procedure for installing SQL Server on the same machine as the 27k1 ISMS application

Introductory note

This procedure demonstrates how to install SQL Server Express on the same computer as the 27k1 ISMS app, please carefully follow each part of the procedure to ensure a stress free installation.

Please note that the 27k1 recommended  method is to deploy SQL Server on a remote machine or to deploy Azure SQL Database.

Installing SQL Server Express

Download SQL Server Express 2019 from the Microsoft website.

https://www.microsoft.com/en-gb/download/details.aspx?id=101064

When the installation file is downloaded, run it by double-clicking, you will need your Window’s administrator password at hand.

Choose the Custom option.

Image

Specify a location for the Media to be stored.

  • To prevent access deny errors specifiy a location on your hard drive where your everyday files are stored.
Image
SQL Server Express
 Start the installation, select the menu options as shown.
Image
Install Rules. Ignore the firewall rules since the installation is on the same PC.
Image
Accept the license terms.

Feature selection

  • Select only the two options shown
SQL Server Express

Instance configuration

  • Assign the instance as shown
Image

Configure SQL Server during the installation process

  • Change the SQL Server Browser to “Automatic” from “Disabled”. This can be carried out later
Image

  • It is very important to add your user name as “Specify SQL Server administrators”.

  • Click "Add"
Image
Image
  • Click “Advanced…”
  • Click "Find Now"
  • Select your user name from the list and then “OK”
Image

Your user name is now selected and must show on the dialog as shown.

  • Click “Next >”
Image
Image
Everything should show green.
Image

Final Configuration

  • Search Windows for “Computer Management”
  • Right click and "Run as Administrator"
  • Double click TCP/IP and Enable TCP/IP
Image
Image
  • If Stopped, double-click “SQL Server Browser” and set to Automatic start.
  • Apply
Image
  • If Stopped, double-click “SQL Server Browser” and set to Automatic start.
Image
  • Right-click to start SQL Server Browser
Image
Image

  • Right-click “SQL Server (SQLEXPRESS) and restart the service

Image

Enable the 27k1 ISMS app loopback exemption

Image
    • Exempt the 27k1 ISMS app from loopback restrictions
    • Copy, paste this command at the prompt

  • checknetisolation.exe loopbackexempt -a -n=27k1.isms_5rha47rvhm3pe

Download and install SQL Server Management Studio (SSMS)

Image
  • Right-click Databases
  • Select “New Database"
Image
  • Enter a suitable database name and click “OK”
Image

Install and configure the 27k1 ISMS

Follow the instructions to install and configure the 27k1 ISMS.

https://knowledgebase.27k1.com/how-to-install-the-27k1-isms

… end of procedure