SQL Server 2019 Installation Guide [Developer Edition]

This guide will help Visual Expert 2020 users to install SQL Server 2019 Developer edition.

Note: SQL Server is necessary to create the VE Repository and store code analysis data.

>> Download SQL Server 2019 Developer Edition

Once you have downloaded the .exe file, follow these steps to install and create an instance of SQL Server :

  1. Run the .exe file and choose "Download Media".

    Run SQL Server Exe File

  2. Select your Language, choose the ‘ISO’ package and your preferred Download Location. Then, click on ‘Download’.

    Choose ISO Package, language & download location

  3. The downloading process for the ISO package file begins.

    Downloading ISO Package Begins

  4. On successful download, click on ‘Open Folder’ to locate the ISO file.

    Locate the ISO File

  5. Right click on the ISO file and click on ‘Mount’ to access the package files.

    Access ISO Package Files

  6. Locate the installation package and setup file.

    Locate the SQL Server 2019 Setup File

  7. Right click on the setup file, and select "Run As Administrator".

    Run Setup File as Administrator

  8. The SQL Server Installation Center opens.
    Select the first option:
    "New SQL Server stand-alone installation or add features to an existing installation"

    New SQL Server Stand-alone Installation

  9. In the "Product Key" section, choose the "Developer" edition and click on "Next".

    Developer Edition Product Key

  10. Accept the license terms and click on "Next".

    Accept the license and terms

  11. Make sure all "Global Rules" pass the test and click "Next".

    Global Rules Scanning Test

  12. In the "Microsoft Update" window, enable "Check for Updates" to allow the installer to automatically check for possible software updates.
    Click on "Next".

    Check for Microsoft Updates

  13. The setup files will get installed in the next window - Install Setup Files.

    Install Setup Files

  14. The "Feature Selection" window allows you to select which SQL Server components will be installed.

    Install Selected Components of SQL Server

  15. Select the "Instance features" as shown below, as they are mandatory for SQL Server to work with Visual Expert. Then, click "Next".

    Mandatory Instance Features for Visual Expert

  16. In the "Instance Configuration" window, create a "VE_Server" Named instance and click "Next".

    Name Instance Configuration

  17. The "Server Configuration" window allows users to configure Service Accounts.
    Click "Next" if no change is required in the default account settings.

    Server Configuration Window

  18. In the Database Engine Configuration window, under the Server Configuration tab, select "Mixed Mode" authentication.
    Doing so will allow you to set a password for "System Administrator (sa)" user.

    Database Engine Configuration

  19. Click on "Add Current User" to set the current user as Administrator for this SQL Server instance. Then, click "Next".

    Add Current User as Administrator

  20. Arriving at the 'Feature Configuration Rules' window, make sure all the Rule(s) pass the installer scanning test. Then, click 'Next'.

    Feature Configuration Rules

  21. All configuration steps have been completed. Click "Install" to start the installation.

    Install SQL Server 2019 Developer Edition

  22. The installation begins.

    Installation of SQL Server 2019 Begins

  23. The installation of SQL Server 2019 Developer Edition is completed.

    Installation of SQL Server 2019 Completed

You can now Create your VE Repository and connect it with your SQL server instance.

 

Visual Expert 2020, SQL Server, Oracle, PowerBuilder, Setup