LAST UPDATED: 6 June 2024

A guide for installing SQL Server Database

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

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

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

The procedure for SQL Server 2022 is similar to 2019 which is shown below.

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

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