Problem :-
In this 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.
Now 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.
https://www.microsoft.com/en-us/download/details.aspx?id=55994
When you complete the downloaded file, the installer will open a window that you can see on the next screen capture.
SQL Server Express Basic Installation
That 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.
When the installation process is finished you will see something as below screenshot.
You can see on the above screen shot, 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.
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.
SQL Server Express Custom Install
The Custom install procedure is the right choice if you want to choose what features you want to install
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.
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.
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.
Finally, you will see the Feature Selection view, where you not only select the features which
After this step you will be asked about the name for the instance you are installing.
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.
In the Collation tab you can customize the 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.
On the Data Directories tab you must specify the directories used by SQL Server to hold the binaries and data, as below screenshot.
On the TempDB tab, you must define the TempDB size, number of files and the directories to be used to hold each file.
User Instances tab asks if you want to do 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.
The last tab asks you about enabling Filestream. This feature is required in case you want to use Memory Optimized tables.
You must press the Accept button and then continue with Next button.
If all process is everything fine then you will see successful message as below in screenshot.
That’s it.