SQL Server 2019 Express Step by Step Download, Install and Configure

By:   |   Updated: 2023-01-11   |   Comments   |   Related: More > SQL Server 2019


Problem

How do you install, configure and access Microsoft SQL Server 2019 Express Edition as well as LocalDB?

Solution

In this tutorial, you will learn the step-by-step process to install and configure SQL Server 2019 Express Edition and LocalDB. Moreover, you will learn how to configure the LocalDB and access the functionality using SQL Server Management Studio.

Download Microsoft SQL Server Express Edition

You can download the SQL Server 2019 from the Microsoft.com official website.

Once the installation file is downloaded, execute it. Select the Download media option from the "Select an installation type" dialog box.

sql sever 2019 express edition download

On the "Specify SQL Server installer download" screen, you need to specify the following options:

  1. Language: choose the language of the SQL Server
  2. Package type: you can select
    1. Express core: the installer will download the SQL Server database engine.
    2. Express Advanced: the installer will download the SQL Server database engine, Reporting Services, and Full-Text Services.
    3. LocalDB: the installer will download the lightweight version of the express edition will all programming features.
  3. Location: specify the directory location where you want to store the SQL Server installation package.

We will download the Express Advanced package.

sql sever 2019 express edition download

The installer file named SQLEXPPRADV_x64_ENU.exe has been downloaded.

sql sever 2019 express edition download

Double-click the file to begin the installation process.

Installation of SQL Server Express Edition

The first step of the Express installation is to specify the directory where you want to extract the files in the Windows operating system. Specify the desired directory location to extract the files and be sure to have sufficient disk space.

sql sever 2019 express edition download

Once files are extracted, start the installation process by running the setup.exe file.

sql sever 2019 express edition executable

The SQL Server Installation Center opens. Select Installation from the left pane and select the New SQL Server stand-alone installation option.

sql sever 2019 express edition installation center

First, the installation wizard checks for Product Updates.

sql sever 2019 express edition install product updates

On the Install Rules screen, the install will check all setup rules. If any of the rules fail, we must fix them before the installation will continue.

sql sever 2019 express edition install rules

On the Installation Type screen, you can select any of the following options

  1. Perform a new installation of SQL Server 2019 Express edition.
  2. Add a feature to the existing instance of the SQL Server.

We are installing a new instance of SQL Server 2019.

sql sever 2019 express edition install installation type

On the License Terms screen, review the Microsoft Software license terms for SQL Server 2019 express edition. Click on I Accept.

sql sever 2019 express edition install license terms

On the Feature Selection screen, you can select the features you want to install. We are installing a database engine and localdb, therefore I selected those features in the list.

sql sever 2019 express edition install feature selection

On Instance Configuration, specify the name of the SQL Server instance. We are using a named instance, therefore I have selected it and named it SQLExpress_2019.

sql sever 2019 express edition install instance configuration

On the Server Configuration screen, specify the service accounts for the SQL Server database engine and SQL Server browser services. If you want to enable the instant file initialization, select "Grant Perform Volume Maintenance Task privilege...".

sql sever 2019 express edition install server configuration

The next screen, Database Engine Configuration, is used to set the database engine configuration parameters. The parameters are in six different tabs: Server Configuration, Data Directories, TempDB, Memory, User Instances, and FILESTREAM.

Server Configuration: specify the following parameters

  1. Authentication Mode: it can be Windows Authentication or Mixed mode (Windows authentication + SQL Server authentication)
  2. Password of SA user: specify the password for SA user.
  3. Specify SQL Server administrator: specify the list of SQL Server administrators.
sql sever 2019 express edition install database engine configuration

Data Directories: You can specify the location of SQL Server database files.

  1. Database root directory: specify the location of the SQL Express database root directory.
  2. User database datafile directory: specify the data file (database primary and secondary data file) directory for the user database.
  3. User database log file directory: specify the log file (transaction log) directory for the user database.
  4. Backup directory: specify the backup directory (directory where the backups are stored).
sql sever 2019 express edition install database engine configuration

TempDB: Specify the following parameters of the TempDB database

  1. Data Files
    1. Number of files for the TempDB database.
    2. Initial Size: initial size of each TempDB database file.
    3. Autogrowth: specify the value of an auto-growth parameter of the TempDB data files.
    4. Data directory: specify the location of the data files for the TempDB database.
  2. Log File
    1. Initial size of the TempDB log file.
    2. Autogrowth: specify the value of an auto-growth parameter of the TempDB log file.
    3. Log directory: specify the location of the log file of the TempDB database.
sql sever 2019 express edition install database engine configuration

Memory: Specify the memory values in MBs that you want to allocate to the SQL Server database engine. We can manually set the Minimum and Maximum memory parameter values, or we can use the default values of Min Server memory and Max Server Memory.

sql sever 2019 express edition install database engine configuration

Click Next to save the configuration and begin the installation of SQL Server express. Once installation completes, you can view the summary and log of the installation process.

sql sever 2019 express edition install complete

As you can see, the SQL Server database engine services and LocalDB have been installed. Now, let's connect and use the LocalDB in SQL Server express edition.

Connect to SQL Server LocalDB using SQL Server Management Studio

We can use the named pipe protocol to connect to SQL Server Express edition LocalDB. To do that, first, we must obtain the pipe name, which can be obtained from SQL Server Configuration Manager.

Open a command prompt with administrative access and Run SQLServerManager15.msc.

  • Expand SQL Server Network Configuration
  • Click on Protocols for SQLEXPRESS_2019
  • Right-click on Named Pipes
  • Select Properties.
sql server configuration manager named pipes

A dialog box opens and you can see the Pipe Name which can be used to connect to the SQL Server Express LocalDB.

named pipes properties

We will use the Pipe Name as the hostname in SQL Server Management Studio. Open SSMS and on the Connect to Server window, specify the pipe name in the Server name text box, and click connect.

connect to sql server

The connection will be established.

Let us run a query to view the version of SQL Server.

SELECT @@version
go

Results

query results

As you can see in the above screenshot, the query has returned the SQL Server version, which shows that the LocalDB database instance is up and running.

Next Steps

In this article, we learned how to install SQL Server 2019 Express Edition and how to connect and configure the LocalDB.

Check out these related articles:






get scripts

next tip button



About the author
MSSQLTips author Nirali Shastri Nirali Shastri is an experienced Core Database Administrator having more than 4 years of experience managing large SQL Databases.

View all my tips


Article Last Updated: 2023-01-11

Comments For This Article

















get free sql tips
agree to terms