LAST UPDATED: 15th June 2021

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 from the Microsoft website.

https://www.microsoft.com/en-us/download/details.aspx?id=55994

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
Image
 Start the installation, select the menu options as shown.
Image
Image
Install Rules. Ignore the firewall rules since the installation is on the same PC.
Image
Image

Feature selection

  • Select only the two options shown
Image

Feature selection

  • 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”.

    • If you are signed in as a standard account, click “Add Current User”
Image
  • Otherwise click “Add…”
Image
  • Click “Advanced…”
  • 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 and open “Computer Management”
  • 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_8xrj8vy0tt35j

    • Tip! In the event of a Windows seasonal update it is possible that the exemption is removed and will need to be reinserted.

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