Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
Untangle TempDB Performance with SQL Diagnostic Manager - Free Webinar
 

Installing SQL Server 2017 Express


By:   |   Last Updated: 2018-07-20   |   Comments (5)   |   Related Tips: More > Express Edition

Problem

In this tip I will go through the steps to install SQL Server 2017 Express, so you can install it on your own.

Solution

Microsoft provides a lightweight edition of SQL Server known as SQL Server Express. If you have had the chance to read my previous article about the Versions of SQL Server Express, you already know that SQL Server Express has evolved and there are three different versions of SQL Server Express you can install according to your needs.

In this tip we will look at the different installation options for SQL Server Express.

SQL Server Express Installation Procedure

In order to install any edition of SQL Server 2017 Express, first you have to download the installer from the following link and select your language as shown on the next screen capture.

Screen Capture - Description: In order to download the installer, first you need to specify your desired language.

When you execute the downloaded file, the installer will open a window that you can see on the next screen capture.

Screen Capture 2 - Description: This is how the installer looks like.

That window offers three possible ways to install SQL Server Express Edition which are Basic, Custom and Download Media. I will show you each of those ways, so keep reading.

SQL Server Express Basic Installation

As you may guess by its name, this is the easiest way to install SQL Server Express Edition. If you decide to use this option you won’t be asked for any configuration information except for the destination path to install and then the installer will download and install the product with the default settings and instance name SQLEXPRESS. As a consequence of this, in the case where you already have an instance of SQL Server Express installed and you use the basic install, the new instance will be named SQLEXPRESS01. So in case you need a particular name for the SQL Server Express instance you should not use the Basic install.

Screen Capture 3 - Description: The installer downloads and installs the product.

When the installation process finishes you will see something similar to the next screen capture.

Screen Capture 4 - Description: This is what you will see when the installer finishes its work.

As you can see on the previous screen capture, the installer gives you data about the installed instance like folders and the connection string. Furthermore, you have three buttons which from left to right are named “Connect Now”, “Customize” and “Install SSMS”.

The “Connect Now” button will open a SQLCMD shell connected to the new instance and executes SELECT @@VERSION and leaves the shell open for you to use as you can see on the next image.

Screen Capture 5 - Description: You can start using your SQL Server Express instance right away after installed.

The “Customize” button runs the advanced installer so you can add or remove other features. Finally the “Install SSMS” button opens a web browser window to the Download SQL Server Management Studio (SSMS) web page.

Download Media Installation Option for SQL Server Express

You can download the SQL Server Express installation files in case you need to install SQL Server Express on a computer without an internet connection. In such a case, you will be asked for the language of the installer files, the download folder location and the type of installer package you want to download.

You can select between the following options:

  • Express Core (294 MB): SQL Server Engine only
  • Express Advanced (732 MB) SQL Server Engine, Full Text Services and Reporting Services
  • LocalDB (46 MB): Lightweight version of Express Edition that runs in user mode.
Screen Capture 19 - Description: You can download the SQL Server Express installation files.

SQL Server Express Custom Install

The Custom install procedure is the right choice if you want to choose what features you want to install. You will be prompted for some configuration options because this installation procedure is more detailed than the Basic option.

The first question you will have to answer is your desired location for the installer files. Take into consideration that you will need 283 MB of free space just to download the installer. The space for the installation of SQL Server Express is not included within those 283 MB.

Screen Capture 6 - Description: You must specify a folder for the downloaded files.

After the download finishes, the installer will launch the SQL Server Installation Center.  On the following image you can see that you are not limited to install a new SQL Server Express instance or add features to an existing installation.  It gives you the chance to download and install Reporting Services, SQL Server Management Tools, SQL Server Data Tools and to upgrade from a previous version of SQL Server Express.

Screen Capture 6 - Description: SQL Server Installation Center.

When you choose to install a new instance, first you will be asked if you agree with the license terms and of course if you want to continue installing SQL Server Express you must agree to the terms. Then the Installation center will check if your system complies with the installation rules.

Screen Capture 7 - Description: Rule checking.

Finally, you will see the Feature Selection view, where you not only select the features you want to install, but specify the destination folders for the root instance and the shared features.

Screen Capture 8 - Description: You can select the features you want to install.

After this step you will be asked about the name for the instance you are installing.

Screen Capture 9 - Description: With the Custom Installer you are able to select the instance name.

After that, you will be asked for the service accounts and if you want to grant the Perform Volume Maintenance Task privilege to the SQL Server service account to take advantage of instant file initialization.

Screen Capture 10 - Description: You must select the service account names.

In the Collation tab you can customize the instance collation.

Screen Capture 11 - Description: You must select an instance collation.

Continuing with the installation, you will be asked if you want to use Windows only authentication mode or mixed mode. If you decide to use mixed mode you must enter a password for the SA account. Additionally, you need to add Windows users or groups as SQL Server Administrators.

Screen Capture 12 - Description: Authentication Mode Configuration.

On the Data Directories tab you must specify the directories used by SQL Server to hold the binaries and data.

Screen Capture 13 - Description: Setting Up Data Directories.

On the TempDB tab, you must define the TempDB size, number of files and the directories to be used to hold each file. If you feel lost with these settings you can take a look at the following tip TempDB Configuration Best Practices in SQL Server.

Screen Capture 14 - Description: Configuring Tempdb.

The User Instances tab asks if you want to enable the Users Instances feature that permits local users who don’t have administrator permission run a separate instance of SQL Server on the machine.

Screen Capture 15 - Description: Configuring User Instances.

The last tab asks you about enabling Filestream. This feature is required in case you want to use Memory Optimized tables. You can get more information about Filestream on the SQL Server FILESTREAM Tips Category.

Screen Capture 16 - Description: Enabling FILESTREAM.

In case you are installing Machine Learning Services you will be asked for your consent to install Microsoft R Open and Python. You must press the Accept button and then continue with Next button.

Screen Capture 17 - Description: You must give your consent to install Microsoft R Open and Python.

Finally, after those steps the installer starts the installation, and if everything is fine you will see the following message.

Screen Capture 18 - Description: Screen capture of the end of the installation process.
Next Steps


Last Updated: 2018-07-20


next webcast button


next tip button



About the author
MSSQLTips author Daniel Farina Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Tuesday, November 27, 2018 - 9:54:49 AM - Jorge Back To Top

 thank's


Tuesday, October 09, 2018 - 10:37:59 PM - Daniel Farina Back To Top

 

Hi WOLFGANG LEY,

I'm glad this tip was helpful for you! If you have some time would you consider to vote me for the Author of the Year https://www.mssqltips.com/mssqltips-author-of-year/ ?

Thank you very much for reading!


Tuesday, October 09, 2018 - 1:22:41 PM - WOLFGANG LEY Back To Top

 Thanks! It helped. I'm working on getting acquainted with MS SQL Server 2017.


Monday, July 23, 2018 - 8:53:30 PM - Daniel Farina Back To Top

Hi Ashok!

There is no 32 bit version of SQL Server 2017. Thanks for reading!


Friday, July 20, 2018 - 6:34:51 AM - Ashok Back To Top

 Hello,

I am unble to instoll SQL SERVER 2017 EXPRESS on my 32- Bit windows system. Could you please let me know, 32-bit windows sys. version of SQL SERVER 2017 available or not ?

 

 

 


Learn more about SQL Server tools