SQL Installations
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. Installation / System Setup Guides
      3. SQL Installations

      SQL Express 2019 Installation

      Overview

      Default guide on how to install SQL 2019 along with SSMS and SQL CE 3.5 

      PROCEDURE

      SQL Express 2019 Installation

       

      Prerequisites

      Server minimum requirements

      • Supported Operating System: Windows 10 or Greater, Windows Server 2016 or Greater

      • Processor:  Intel-compatible processor with a minimum spec of i5 or a faster processor Recommended i7

      • RAM:  Minimum 16 GB

      • Hard Disk Space:   60 GB of Disk Space

      • Software: Frameworks 4.8

      Resources

      SQL Express 2019

      SQL Server Management Studio (SSMS) 

      SQL CE Installers

      SQL EXPRESS 2019 Installation

      • Once SQL finishes downloading the installation files the setup wizard will launch, this is where the option to install a New SQL Server will present. Click on the Hyperlink to proceed to the next step

       

      • Accept the license terms and click Next.

       

      • Optional you can use Microsoft Update to check for any SQL Updates.  (Default is unchecked), click next to continue.

       

      • Install Rules will highlight any rule failures or software requirements. Click Next to continue.

       

      • Feature Selection by default is set to the correct features, but the Machine Learning Services are not required so these can be unchecked. Click Next to continue 

       

      • Instance Configuration can go with the default name 'SQLExpress' but would recommend renaming this to something more suitable. i.e SQLEX2019 Click Next to continue.

       

      • Server Configuration, ensure SQL Server Browser is set to 'Automatic' and Check Grant Perform Volume Maintence. Click Next to Continue.

       

      • Database Engine Configuration, ensure 'Mixed Mode' is checked and enter a SA (System Administrator) password, Default is normally 'do4safet', also ensure that all Windows Users that require System Admin Rights are specified in the Server Administrators. Click Next to Continue.

       

      • SQL Server should now start the installation process and once finished should show the Complete Window, with a Status for each Feature installed which should all be 'Succeeded', Click Close to Exit the installation Wizard.

       

       

      SQL SERVER MANAGEMENT STUDIO Installation

      • SQL Server Installation Center, select the option to 'Install SQL Server Management Tools.

       

      This will launch a web browser to download the SSMS Installation Package 

       

      • Once Downloaded run the Installation Package 'SSMS-Setup-ENU', Click Install to continue.

       

      • Once installed it is recommended to Restart.

       

      SQL CE 3.5 Installation

      • SQL 3.5 has two files on for Windows x86 (32bit) and Windows x64 (64bit) on a Windows (64Bit) OS both the (32bit) and (64Bit) installers need to be run in order of (32bit) first and then (64bit) second.

      • Run 'SSCERuntime_x86-ENU' and then Run 'SSCERuntime_x64-ENU' the steps below are the same for both installers.

       

      • Accept the Terms in the license agreement and click Next.

       

      • Click Install