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

      SQL Developer 2019 Installation (Internal Use Only)

      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 Developer 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 'Unselect - All',  and Enable Database Engine Services Only (SQLEngine) - Click Next

       

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

       

      • Server Configuration, ensure SQL Server Browser is set to 'Automatic' and Grant Perform Volume maintenance this added SQL to a special service group and helps with how it allocated disk space,  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.

       

      • Ready to Install - Click Install 

      Installation should complete with the following services 

      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